//从form 中获取fileData
HttpFileCollection files = Request.Files;
byte[] fileData = new byte[files[0].ContentLength];
files[0].InputStream.Read(fileData, 0, fileData.Length);
void FileStateHandle(string connstr, OptType opt, string fileName,byte[] fileData, string state, string message)
{
SqlConnection sqlconn;
string commandText = null;
SqlCommand cmd = new SqlCommand();
message = message.Replace("'", "''");
fileName = fileName.Replace("'", "''");
sqlconn = new SqlConnection(connstr);
switch(opt){
case OptType.Insert:
commandText = "insert into dbo.SalesTraceUploadedFiles(FileName,FileData,State,Message,Date) select "
+ "'" + fileName + "'"
+ ", @fileData&