public void ProcessRequest(HttpContext context)
{
SRCom srCom = new SRCom();
//保存图片
string err = "";
string path = "";
int status = 0;
string imgNamePath = "";
//string miniImgNamePath = "";
string filesPath = @"/slip/Sources/TempFiles/";
string allowFileExt = "jpg,jpeg,gif,png";
try
{
SRUploadFile fileUpload = new SRUploadFile(filesPath, allowFileExt, null);
HttpPostedFile file = HttpContext.Current.Request.Files["logo_file"];
status = fileUpload.UploadFile(file);
//设置默认文件上传大小
//设置上传路径
fileUpload.AllowFileExt = "jpg,jpeg,png,";//文件可上传类型
switch (status)
{
case 5: err = "未选择文件";
break;
case 1: err = "文件大小为0";
break;
case 2: err = "文件大小超过4M";
break;
case 3: err = "文件类型不明确";
break;
case 4: err = "该文件类型不允许上传，可上传文件类型为：" + fileUpload.AllowFileExt;
break;
case 0:
path = fileUpload.filesPath + fileUpload.fileName;
SRCreatThumbnail setThumbnail = new SRCreatThumbnail();
setThumbnail.NewImgPath = @"/slip/Sources/TempFiles/";
setThumbnail.MaxImgWidth = 500;
setThumbnail.CreatThumbnail(path);//存储图片至新位置并设置缩略图
imgNamePath = setThumbnail.NewImgPath + setThumbnail.NewImgName;
break;
default:
err = "未知错误：";
status = 6;
break;
}
}
catch (Exception ex)
{
err = ex.ToString();
}
context.Response.ContentType = "text/html";
context.Response.Write("{'status':'" + status.ToString() + "','error':'" + err + "','imgNamePath':'" + srCom.jsonString(imgNamePath) + "','path':'" + srCom.jsonString(path) + "'}");
context.Response.End();
}
public void ProcessRequest(HttpContext context)
{
string err = "";
int status = 0;
// context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
SRCom srCom = new SRCom();
int avatar_x = (int)Convert.ToDouble(context.Request["px"]);
int avatar_y = (int)Convert.ToDouble(context.Request["py"]);
int avatar_w = (int)Convert.ToDouble(context.Request["pw"]);
int avatar_h = (int)Convert.ToDouble(context.Request["ph"]);
int topicID = (int)Convert.ToDouble(context.Request["tid"]);
string img = context.Request["img"].ToString();
string oldImg = context.Request["oldImg"].ToString();
string logoMini = "";
string logo = "";
string logoOriginal = "";
if (avatar_w > 0)
{
SRCutImage sweet_cutimg = new SRCutImage(avatar_x, avatar_y, avatar_w, avatar_h, 100, 125);
sweet_cutimg.imgSaveFolder = @"/slip/Sources/ProjectImg/Logo/Mini/";
logoMini = sweet_cutimg.Sweet_Cut(img);
logo = srCom.MoveFile(img, @"/slip/Sources/ProjectImg/Logo/");
logoOriginal = srCom.MoveFile(oldImg,@"/slip/Sources/ProjectImg/Logo/Original/");
}
SRSql srSql = new SRSql();
SRSql srSql_ = new SRSql();
srSql.conn.Open();
srSql_.conn.Open();
//删除原图片
srSql_.cmd.CommandText = "select topicLogo, topicLogoOriginal,topicLogoMini from topicTB where topicID = @tid";
srSql_.cmd.Parameters.AddWithValue("@tid", topicID);
srSql_.da.Fill(srSql_.ds,"tb_topic_img");
srCom.DeleteFile(srSql_.ds.Tables["tb_topic_img"].Rows[0]["topicLogo"].ToString());
srCom.DeleteFile(srSql_.ds.Tables["tb_topic_img"].Rows[0]["topicLogoOriginal"].ToString());
srCom.DeleteFile(srSql_.ds.Tables["tb_topic_img"].Rows[0]["topicLogoMini"].ToString());
srSql.cmd.CommandText = "update topicTB set topicLogo= @logo, topicLogoOriginal = @logoOriginal ,topicLogoMini= @logoMini where topicID = @tid";
srSql.cmd.Parameters.AddWithValue("@logo", logo);
srSql.cmd.Parameters.AddWithValue("@logoOriginal", logoOriginal);
srSql.cmd.Parameters.AddWithValue("@logoMini", logoMini);
srSql.cmd.Parameters.AddWithValue("@tid", topicID);
srSql.cmd.ExecuteNonQuery();
srSql.conn.Close();
srSql_.conn.Close();
context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8");
context.Response.Write("{\"status\":\"" + status.ToString() + "\",\"error\":\"" + err + "\",\"logo\":\"" + srCom.jsonString(logo) + "\",\"logoMini\":\"" + srCom.jsonString(logoMini) + "\"}");
context.Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
SRCom srCom = new SRCom();
//保存图片
string err = "";
string path = "";
int status = 0;
string filesPath = @"/slip/Sources/TempFiles/";
string allowFileExt = "jpg,jpeg,gif,png";
try
{
SRUploadFile fileUpload = new SRUploadFile(filesPath, allowFileExt, null);
HttpPostedFile file = HttpContext.Current.Request.Files["Fileupload"];
status = fileUpload.UploadFile(file);
//设置默认文件上传大小
//设置上传路径
fileUpload.AllowFileExt = "jpg,jpeg,png,";//文件可上传类型
switch (status)
{
case 5: err = "未选择文件";
break;
case 1: err = "文件大小为0";
break;
case 2: err = "文件大小超过4M";
break;
case 3: err = "文件类型不明确";
break;
case 4: err = "该文件类型不允许上传，可上传文件类型为：" + fileUpload.AllowFileExt;
break;
case 0:
path = fileUpload.filesPath + fileUpload.fileName;
break;
default:
err = "未知错误：";
status = 6;
break;
}
}
catch (Exception ex)
{
err = ex.ToString();
}
this.LabelData.Text = ("{\"status\":\"" + status.ToString() + "\",\"error\":\"" + err + "\",\"path\":\"" + srCom.jsonString(path) + "\"}");
//Response.End();
}
}
public void ProcessRequest(HttpContext context)
{
int status = 0;
string error = "";
SRSql srSql = new SRSql();
SRSql srSql_ = new SRSql();
try
{
int topicImgID = Convert.ToInt32(context.Request["imgID"]);
// SRSql srSql = new SRSql();
srSql.conn.Open();
srSql.cmd.CommandText = "select * from topicImgTB where topicImgID = @imgID";
srSql.cmd.Parameters.AddWithValue("@imgID", topicImgID);
srSql.dr = srSql.cmd.ExecuteReader();
srSql.dr.Read();
string topicImgFile = srSql.dr["topicImgFile"].ToString();
string topicImgMini = srSql.dr["topicImgMini"].ToString();
string topicImgOriginal = srSql.dr["topicImgOr"].ToString();
srSql.conn.Close();
SRCom srCom = new SRCom();
srCom.DeleteFile(topicImgFile);
srCom.DeleteFile(topicImgMini);
srCom.DeleteFile(topicImgOriginal);
srSql_.conn.Open();
srSql_.cmd.CommandText = "delete from topicImgTB where topicImgID = @imgID";
srSql_.cmd.Parameters.AddWithValue("@imgID", topicImgID);
srSql_.cmd.ExecuteNonQuery();
srSql_.conn.Close();
srSql.conn.Close();
}
catch(Exception ex){
error = ex.ToString();
srSql_.conn.Close();
srSql.conn.Close();
status = 1;
}
finally{
srSql.conn.Close();
srSql_.conn.Close();
context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8");
context.Response.Write("{\"status\":\"" + status.ToString() + "\",\"error\":\"" + error + "\"}");
context.Response.End();
}
}
public void ProcessRequest(HttpContext context)
{
SRCom srCom = new SRCom();
//保存图片
string err = "";
string path = "";
int status = 0;
int imgID=0;
string imgNamePath = "";
string miniImgNamePath = "";
string filesPath = @"/slip/Sources/ProjectImg/Original/";
string allowFileExt = "jpg,jpeg,gif,png";
try
{
SRUploadFile fileUpload = new SRUploadFile(filesPath, allowFileExt, null);
HttpPostedFile file = HttpContext.Current.Request.Files["imgFile"];
status = fileUpload.UploadFile(file);
//设置默认文件上传大小
//设置上传路径
fileUpload.AllowFileExt = "jpg,jpeg,png,";//文件可上传类型
switch (status)
{
case 5: err = "未选择文件";
break;
case 1: err = "文件大小为0";
break;
case 2: err = "文件大小超过4M";
break;
case 3: err = "文件类型不明确";
break;
case 4: err = "该文件类型不允许上传，可上传文件类型为：" + fileUpload.AllowFileExt;
break;
case 0:
path = fileUpload.filesPath + fileUpload.fileName;
SRCreatThumbnail setThumbnail = new SRCreatThumbnail();
setThumbnail.NewImgPath = @"/slip/Sources/ProjectImg/";
setThumbnail.MaxImgWidth = 500;
setThumbnail.CreatThumbnail(path);
imgNamePath = setThumbnail.NewImgPath + setThumbnail.NewImgName;
setThumbnail.NewImgPath = @"/slip/Sources/ProjectImg/Mini/";
setThumbnail.MaxImgWidth = 200;
setThumbnail.CreatThumbnail(path);
miniImgNamePath = setThumbnail.NewImgPath + setThumbnail.NewImgName;
int topicID = Convert.ToInt32(context.Request.QueryString["tid"]);
SRSql srSql=new SRSql();
srSql.conn.Open();
srSql.cmd.CommandText = "insert into topicImgTB (forTopic, topicImgFile,topicImgOr,topicImgMini) values(@forTopic, @topicImgFile,@topicImgOr,@topicImgMini)";
srSql.cmd.Parameters.AddWithValue("@forTopic",topicID);
srSql.cmd.Parameters.AddWithValue("@topicImgFile", imgNamePath);
srSql.cmd.Parameters.AddWithValue("@topicImgOr", path);
srSql.cmd.Parameters.AddWithValue("@topicImgMini", miniImgNamePath);
srSql.cmd.ExecuteNonQuery();
srSql.conn.Close();
//获取新插入的ID
SRSql srSql_ = new SRSql();
srSql_.conn.Open();
srSql_.cmd.CommandText = "select Max(topicImgID) from topicImgTB where forTopic = @topicID";
srSql_.cmd.Parameters.AddWithValue("@topicID",topicID);
imgID = Convert.ToInt32(srSql_.cmd.ExecuteScalar().ToString());
srSql_.conn.Close();
break;
default:
err = "未知错误：";
status = 6;
break;
}
}
catch (Exception ex)
{
err = ex.ToString();
}
Hashtable jdata = new Hashtable();
jdata["status"] = status;
jdata["error"] = err;
jdata["imgNamePath"] = (miniImgNamePath);
jdata["path"] = (path);
jdata["imgID"] = imgID;
string jdataStr = JsonMapper.ToJson(jdata);
context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8");
context.Response.Write(jdataStr);
context.Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
SRCom srCom = new SRCom();
int userIdentity = Convert.ToInt32(Request.Form["user_identity"]);
string userName = user_name.Text.Trim();//Request.Form[this.user_name.ClientID];
string userMail = user_mail.Text.Trim().ToLower();
string userNumber = user_school_num.Text.Trim();
string userPassword =user_password.Text.Trim();
userPassword = srCom.HashPassword(userPassword);
string userPasswordCompare =user_password_compare.Text.Trim();
string userMobile = user_mobile.Text.Trim();
string userCollege = user_college.Text.Trim();
string userMajor =user_major.Text.Trim();
string userPhoto = Request.Form["userPhoto"];
string userIntro = Request.Form["userIntro"];
int avatar_x = (int)Convert.ToDouble(Request.Form["avatar_x"]);
int avatar_y = (int)Convert.ToDouble(Request.Form["avatar_y"]);
int avatar_w = (int)Convert.ToDouble(Request.Form["avatar_w"]);
int avatar_h = (int)Convert.ToDouble(Request.Form["avatar_h"]);
string img = Request.Form["img"].ToString();
string oldImg = Request.Form["old_img"].ToString();
string avatarMini = "";
string avatar = "";
string avataOriginal = "";
if (avatar_w > 0)
{
SRCutImage sweet_cutimg = new SRCutImage(avatar_x, avatar_y, avatar_w, avatar_h, 120, 120);
sweet_cutimg.imgSaveFolder = @"/slip/Sources/Portraits/Mini/";
avatarMini = sweet_cutimg.Sweet_Cut(img);
avatar = srCom.MoveFile(img, @"/slip/Sources/Portraits/");
avataOriginal = srCom.MoveFile(oldImg, @"/slip/Sources/Portraits/Original/");
}
string postTime = DateTime.Now.ToString();
SRSql srSql = new SRSql();
srSql.conn.Open();
srSql.cmd.CommandText =
"insert into userTB " +
"( userName, userMail, userNumber, userIdentity, userPWD, userMobile, userCollege, userMajor, PostTime,avatarMini,avatar,avataOriginal) VALUES " +
"(@userName,@userMail,@userNumber,@userIdentity,@userPWD,@userMobile,@userCollege,@userMajor,@PostTime,@avatarMini,@avatar,@avataOriginal) ";
srSql.cmd.Parameters.AddWithValue("@userName", userName == null ? "" : userName);
srSql.cmd.Parameters.AddWithValue("@userMail", userMail == null ? "" : userMail);
srSql.cmd.Parameters.AddWithValue("@userNumber", userNumber == null ? "" : userNumber);
srSql.cmd.Parameters.AddWithValue("@userIdentity", userIdentity);
srSql.cmd.Parameters.AddWithValue("@userPWD", userPassword == null ? "" : userPassword);
srSql.cmd.Parameters.AddWithValue("@userMobile", userMobile == null ? "" : userMobile);
srSql.cmd.Parameters.AddWithValue("@userCollege", userCollege == null ? "" : userCollege);
srSql.cmd.Parameters.AddWithValue("@userMajor", userMajor == null ? "" : userMajor);
srSql.cmd.Parameters.AddWithValue("@PostTime", postTime);
srSql.cmd.Parameters.AddWithValue("@avatarMini", avatarMini == null ? "" : avatarMini);
srSql.cmd.Parameters.AddWithValue("@avatar", avatar == null ? "" : avatar);
srSql.cmd.Parameters.AddWithValue("@avataOriginal", avataOriginal == null ? "" : avataOriginal);
srSql.cmd.ExecuteNonQuery();
srSql.conn.Close();
Response.Redirect("logOn.aspx?f=new_register");
}
}
/// <summary>
/// 创建图像
/// </summary>
/// <param name="imgPath">图片的相对服务器跟路径</param>
/// <returns></returns>
public int CreatThumbnail(string imgPath)
{
SRCom srCom = new SRCom();
string fileNewName = System.DateTime.Now.ToString("yyyyMMddHHmmssffff");//重命名文件名，防止重复
string imgAbsPath = AppDomain.CurrentDomain.BaseDirectory + imgPath;//原图像绝对地址
Image image = Image.FromFile(imgAbsPath); //利用Image对象装载源图像
string imgExt = "."+srCom.GetFileExt(imgPath);
NewImgName = fileNewName + imgExt;
//MiniImgName = "mini" + fileNewName + imgExt;
SaveThumbnail(NewImgPath, NewImgName, image, MaxImgWidth, ImgCompressLever);//存储新图像
// SaveThumbnail(MiniImgPath, MiniImgName, image, MiniImgWidth, MiniImgCompressLever);//存储缩略图
image.Dispose();
//srCom.DeleteFile(imgPath);//删除原图像
return 0;
}
/// <summary>
/// 上传文件
/// </summary>
/// <param name="file"></param>
/// <returns>0为文件不存在，1文件大小为0，2文件大小超过4M，3不存在文件类型，4不允许的上传类型，5上传成功</returns>
public int UploadFile(HttpPostedFile file)
{
SRCom srCom = new SRCom();
string FilesPath = AppDomain.CurrentDomain.BaseDirectory + filesPath;
if (null == file) return 5;//文件不存在
if (!(file.ContentLength > 0)) return 1;//文件大小为0
if (file.ContentLength > 4194304) return 2;//文件大小超过4M
fileName = file.FileName;//获取文件名
fileExt = Path.GetExtension(file.FileName);//获取文件类型
if (null == fileExt) return 3;//不存在文件类型
// 截取上载文件后缀名，不含“.”
string extension = srCom.GetFileExt(fileName);
if (("," + AllowFileExt + ",").IndexOf("," + extension + ",") < 0) return 4;//err = "上传文件扩展名必需为：" + upext;
//检查目录是否存在，不存在则创建
if (!Directory.Exists(FilesPath))
{
Directory.CreateDirectory(FilesPath);
}
string vsnewname = System.DateTime.Now.ToString("yyyyMMddHHmmssffff");//重命名文件名，防止重复
fileName = vsnewname + fileExt;
string path = FilesPath + fileName;
file.SaveAs(path);
return 0;
}
protected void Page_Load(object sender, EventArgs e)
{
if ( Session["userID"] != null)
{
Response.Redirect("Profile");
}
if (Request.QueryString["f"] == "new_register")
{
LabelNewUserTip.Text = "您已经注册成功，请登陆！";
}
if (Request.QueryString["f"] == "unlogin")
{
LabelNewUserTip.Text = "您未登录，请登陆！";
}
#region 处理提交数据
if (IsPostBack)
{
string returnUrl = Request.QueryString["reurl"];
SRCom srCom = new SRCom();
string userAccount = user_account.Text.Trim();
string userPWD = srCom.HashPassword(user_password.Text.Trim());
SRSql srSql = new SRSql();
srSql.conn.Open();
srSql.cmd.CommandText = "select * from userTB where (userMail=@userMail or userNumber=@userNumber or userMobile=@userMobile) order by userID";
srSql.cmd.Parameters.AddWithValue("@userMail", userAccount);
srSql.cmd.Parameters.AddWithValue("@userNumber", userAccount);
srSql.cmd.Parameters.AddWithValue("@userMobile", userAccount);
srSql.da.Fill(srSql.ds, "tb_login_user");
srSql.conn.Close();
int userAmount = 0;
int userAccountAmount = srSql.ds.Tables["tb_login_user"].Rows.Count;
foreach (DataRow dataRow in srSql.ds.Tables["tb_login_user"].Rows)
{
if (dataRow["userPWD"].ToString() == userPWD)
{
userAmount++;
Session["userID"] = dataRow["userID"].ToString();
Session["userName"] = dataRow["userName"].ToString();
Session["userIdentity"] = dataRow["userIdentity"].ToString();
Session["userAvatar"] = dataRow["avatarMini"].ToString();
Session.Timeout = 100;
}
}
if (userAmount > 1)
{
this.LabelLoginUserTip.Text = "该账号存在两个,请更换帐号登陆！";
Session.Abandon();
}
else
{
if (userAccountAmount == 0)
{
this.LabelLoginUserTip.Text = "该账号不存在！";
Session.Abandon();
}
else
{
if (userAmount < 1)
{
this.LabelLoginUserTip.Text = "密码错误！";
Session.Abandon();
}
else
{
if (returnUrl == "" || returnUrl == null)
{
Response.Redirect("Profile");
}
else
{
Response.Redirect(returnUrl);
}
}
}
}
}
#endregion
}
