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(); 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"); } }