protected void btnSavePhoto_Click(object sender, ImageClickEventArgs e)
{
if (!FileUpload1.HasFile)
{
return;
}
string fileName = FileUpload1.FileName;
string strExtent = fileName.Substring(fileName.LastIndexOf("."));
fileName = CommonFunction.Get_DynamicString() + strExtent;
string fileName1 = "m_" + fileName;
string fileName2 = "v_" + fileName;
string filePath = Server.MapPath("~/RoadPhoto/" + fileName);
string filePath1 = Server.MapPath("~/RoadPhoto/" + fileName1);
string filePath2 = Server.MapPath("~/RoadPhoto/" + fileName2);
FileUpload1.PostedFile.SaveAs(filePath);
ImgFunction.MakeThumbnail(filePath, filePath1, 600, 480, "W");
ImgFunction.MakeThumbnail(filePath, filePath2, 150, 120, "W");
System.IO.File.Delete(filePath);
Image1.ImageUrl = "../RoadPhoto/" + fileName1;
string sqlStr = "update R_RoadDepart set RD_MainPhoto='" + fileName1 + "',RD_ViewPhoto='" + fileName2 + "' where RD_ID='" + ViewState["rdid"].ToString() + "'";
DBHelper.ExecuteCommand(sqlStr);
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
string strAction = ViewState["strAction"].ToString();
string strContent = PubClass.Tool.CheckStr(Request.Form["t_contents"].ToString());
if (cboSel.Checked)
{
if (strAction == "add" && !FileUpload1.HasFile)
{
return;
}
if (FileUpload1.HasFile)
{
string fileName = FileUpload1.FileName;
string strExtent = fileName.Substring(fileName.LastIndexOf("."));
fileName = CommonFunction.Get_DynamicString() + strExtent;
string fileName1 = "v_" + fileName;
string fileName2 = "vv_" + fileName;
string filePath = Server.MapPath("~/NewsImg/" + fileName);
string filePath1 = Server.MapPath("~/NewsImg/" + fileName1);
string filePath2 = Server.MapPath("~/NewsImg/" + fileName2);
FileUpload1.PostedFile.SaveAs(filePath);
ImgFunction.MakeThumbnail(filePath, filePath1, 600, 400, "W");
ImgFunction.MakeThumbnail(filePath, filePath2, 180, 120, "W");
System.IO.File.Delete(filePath);
ViewState["ImgPath"] = fileName1;
ViewState["ImgView"] = fileName2;
}
}
string sqlStr = "";
if (strAction == "add")
{
sqlStr = "insert into S_NewsInfo(N_Title,N_Content,N_From,N_Date,N_TSID,N_TID,N_ImgPath,N_ImgView) values('" + txtTitle.Text.Trim() + "','" + strContent + "','" + txtFrom.Text.Trim() + "','" + txtDate.Text.Trim() + "','" + ((UserInfo)Session["StationUser"]).U_TollStation.TS_ID + "','" + ((DataTable)ViewState["dtType"]).Rows[0]["T_ID"].ToString() + "','" + ViewState["ImgPath"].ToString() + "','" + ViewState["ImgView"].ToString() + "')";
}
else if (strAction == "update")
{
sqlStr = "update S_NewsInfo set N_Title='" + txtTitle.Text.Trim() + "',N_Content='" + strContent + "',N_From='" + txtFrom.Text.Trim() + "',N_Date='" + txtDate.Text.Trim() + "',N_ImgPath='" + ViewState["ImgPath"].ToString() + "',N_ImgView='" + ViewState["ImgView"].ToString() + "' where N_ID='" + ViewState["nid"].ToString() + "'";
}
if (DBHelper.ExecuteCommand(sqlStr) > 0)
{
Response.Redirect(((DataTable)ViewState["dtType"]).Rows[0]["SelectURL"].ToString());
}
}