17,740
社区成员
发帖
与我相关
我的任务
分享
HttpPostedFile oFile = Request.Files["NewFile"];
// Check if the file has been correctly uploaded
if (oFile == null || oFile.ContentLength == 0 || !(Convert.ToInt32(HttpContext.GetGlobalResourceObject("SystemInfo", "OpenFileup")) == 1))
{
SendResults(202);
return;
}
int iErrorNumber = 0;
string sFileUrl = "";
// Get the uploaded file name.
string sFileName = System.IO.Path.GetFileName(oFile.FileName).Substring(System.IO.Path.GetFileName(oFile.FileName).LastIndexOf(".") + 1).ToLower();
string TypeName = HttpContext.GetGlobalResourceObject("SystemInfo", "UpfileTypeSettings").ToString();
if (!TypeName.Contains(sFileName) ||
oFile.ContentLength >= Convert.ToInt32(HttpContext.GetGlobalResourceObject("SystemInfo", "MaxFileLengthSettingsKB")) * 1024)
//文件类型判断 文件大小验证
{
SendResults(202);
return;
}
int iCounter = 0;
while (true)
{
//判断文件是否可以上传
if (CheckUploadFileExtension(sFileName))
{
string sFilePath = System.IO.Path.Combine(this.UserFilesDirectory, sFileName);
if (System.IO.File.Exists(sFilePath))
{
iCounter++;
sFileName =
System.IO.Path.GetFileNameWithoutExtension(oFile.FileName) +
"(" + iCounter + ")" +
System.IO.Path.GetExtension(oFile.FileName);
iErrorNumber = 201;
}
else
{
if (TypeName.Contains(".gif") || TypeName.Contains(".jpg") || TypeName.Contains("bmp") || TypeName.Contains("png"))
{
System.Drawing.Image image = System.Drawing.Image.FromStream(oFile.InputStream);
int width = image.Width;
int height = image.Height;
int max = Convert.ToInt32(HttpContext.GetGlobalResourceObject("SystemInfo", "ImageMaxWidth"));
if (width > max)
{
try
{
System.Drawing.Image newPic; //定义新位图对象
//String picPath = path + userID + time + fileExtension;
if (width > height)
{
newPic = new Bitmap(image, max, height * max / width); //缩放
}
else
{
newPic = new Bitmap(image, width * max / height, max); //缩放
}
newPic.Save(sFilePath, System.Drawing.Imaging.ImageFormat.Bmp); //将处理后的图片保存成bmp文件
sFileUrl = this.UserFilesPath + sFileName;
break;
}
catch
{
}
}
}
oFile.SaveAs(sFilePath);
sFileUrl = this.UserFilesPath + sFileName;
break;
}
}
else
{
//不允许上传
SendResults(202);
break;
}
}
SendResults(iErrorNumber, sFileUrl, sFileName);
/// <summary>
/// 在上传文件时同时将数据存入数据库所做的事务操作,返回是否操作成功
/// </summary>
/// <param name="cmdText">insert命令</param>
/// <param name="myParams">sql参数数组</param>
/// <param name="file">文件上传组件</param>
/// <param name="fileName">保存的文件名</param>
protected bool RunTranscation(string cmdText, OleDbParameter[] myParams, FileUpload file,string fileName)
{
string connectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["McmConnection"].ToString();//连接数据库字符串
OleDbConnection conn = new OleDbConnection(connectionString);//新建连接
conn.Open();//打开连接
OleDbTransaction otran = conn.BeginTransaction();//开启事务
OleDbCommand cmd = new OleDbCommand(cmdText, conn);//创建命令
cmd.Transaction = otran;//设置命令的事物为otran
int result = 0;//判断插入数据库是否成功
//为cmd添加参数
foreach (OleDbParameter param in myParams)
{
cmd.Parameters.Add(param);
}
try
{
result=cmd.ExecuteNonQuery();//执行插入操作
if (result == 1)//如果插入成功
{
//string fileName = file.FileName;//文件名
//string sNewFileName = DateTime.Now.ToString("yyyyMMddhhmmsfff");//以时间来重命名图片
//string sExtension = file.FileName.Substring(file.FileName.LastIndexOf('.'));//图片的后缀名
//file.SaveAs(uploadPath + sNewFileName + sExtension);//保存图片文件
//string filePath = "../Uploads/" + folderName + "/" + sNewFileName + sExtension;//上传到Uploads文件夹的不同的文件夹下
file_pastPaper.SaveAs(Server.MapPath("../"+fileName));//上传到文件夹中
otran.Commit();//提交事务
return true;
}
otran.Rollback();//回滚事务,操作失败
}
catch (Exception se)
{
//Response.Write("<script>alert('"+se.Message+"')</script>");\
//Response.Write("<script>alert('"+se.Message.ToString()+"')</script>");
otran.Rollback();//回滚事务
return false;
}
finally
{
conn.Close();
}
return false;
}