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