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