/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, ImageClickEventArgs e)
{
NoticeMOD mod = null;
int num = 0;
DataSet ds = NoticeBLL.GetmodAll("");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
mod = new NoticeMOD();
mod.Title = txtTitle.Text.Trim();
mod.Contents = txtContents.Value;
num = NoticeBLL.Updatemod(mod);
}
else
{
mod = new NoticeMOD();
mod.Title = txtTitle.Text.Trim();
mod.Contents = txtContents.Value;
num = NoticeBLL.Insertmod(mod);
}
if (num > 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('提交成功');", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('提交失败');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != "" && Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
mod = GuanJiaoZhenImgBLL.GetmodByid(id);
if (mod != null)
{
txtguanJiaoZhenNo.Text = mod.GuanJiaoZhenNo;
if (mod.GuanJiaoZhenImg != "")
{
imgguanJiaoZhenImg.ImageUrl = mod.GuanJiaoZhenImg;
}
else
{
imgguanJiaoZhenImg.ImageUrl = "/images/nophoto.jpg";
}
}
imgguanJiaoZhenImg.Visible = true;
txtguanJiaoZhenNo.Enabled = false;
}
else
{
imgguanJiaoZhenImg.Visible = false;
}
}
}
/// <summary>
/// 根据主键id查询信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static GuanJiaoZhenImgMOD GetmodByid(int id)
{
GuanJiaoZhenImgMOD mod = new GuanJiaoZhenImgMOD();
string sqlcommandString = "select * from GuanJiaoZhenImg where imgId=" + id;
try
{
SqlDataReader reader = SqlHelper.ExecuteReader(sqlcommandString);
if (reader.Read())
{
mod.GuanJiaoZhenImg = reader["GuanJiaoZhenImg"].ToString();
mod.GuanJiaoZhenNo = reader["GuanJiaoZhenNo"].ToString();
mod.ImgId = Convert.ToInt32(reader["imgId"].ToString());
}
reader.Close();
return mod;
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, ImageClickEventArgs e)
{
int num = 0;
if (Request.QueryString["id"] != "" && Request.QueryString["id"] != null)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
mod = GuanJiaoZhenImgBLL.GetmodByid(id);
Boolean fileOK = false;
//上传外形图纸
if (fuguanJiaoZhenImg.HasFile)
{
// 得到文件的后缀
String fileExtension =
System.IO.Path.GetExtension(fuguanJiaoZhenImg.FileName).ToLower();
// 允许的文件后缀
String[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg" };
// 看包含的文件是否是被允许的文件后缀
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (fileExtension == allowedExtensions[i])
{
// 如果是，标志位置为真
fileOK = true;
}
}
if (fileOK)
{
string url = "~/fileUpload/gjz_" + mod.GuanJiaoZhenNo+fileExtension;
if (fuguanJiaoZhenImg.HasFile)
{
string fileType = fuguanJiaoZhenImg.PostedFile.ContentType;
string name = fuguanJiaoZhenImg.PostedFile.FileName; //文件路径
FileInfo fileInfo = new FileInfo(name);
try
{
fuguanJiaoZhenImg.SaveAs(Server.MapPath(url));
mod.GuanJiaoZhenImg = url;
fileOK = false;
}
catch (Exception ex)
{
Response.Write("<script>alert('上传有误，请重新上传!');</script>");
}
}
}
else
{
Response.Write("<script>alert('只能上传gif,png,jpeg,jpg格式的文件!');</script>");
return;
}
}
num = GuanJiaoZhenImgBLL.Updatemod(mod);
}
else
{
mod = new GuanJiaoZhenImgMOD();
mod.GuanJiaoZhenNo = txtguanJiaoZhenNo.Text.Trim();
Boolean fileOK = false;
//上传外形图纸
if (fuguanJiaoZhenImg.HasFile)
{
// 得到文件的后缀
String fileExtension =
System.IO.Path.GetExtension(fuguanJiaoZhenImg.FileName).ToLower();
// 允许的文件后缀
String[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg" };
// 看包含的文件是否是被允许的文件后缀
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (fileExtension == allowedExtensions[i])
{
// 如果是，标志位置为真
fileOK = true;
}
}
if (fileOK)
{
string url = "~/fileUpload/gjz_" + mod.GuanJiaoZhenNo + fileExtension;
if (fuguanJiaoZhenImg.HasFile)
{
string fileType = fuguanJiaoZhenImg.PostedFile.ContentType;
string name = fuguanJiaoZhenImg.PostedFile.FileName; //文件路径
FileInfo fileInfo = new FileInfo(name);
try
{
fuguanJiaoZhenImg.SaveAs(Server.MapPath(url));
mod.GuanJiaoZhenImg = url;
fileOK = false;
}
catch (Exception ex)
{
Response.Write("<script>alert('上传有误，请重新上传!');</script>");
}
}
}
else
{
Response.Write("<script>alert('只能上传gif,png,jpeg,jpg格式的文件!');</script>");
return;
}
}
else
{
mod.GuanJiaoZhenImg = "";
}
num = GuanJiaoZhenImgBLL.Insertmod(mod);
}
if (num > 0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "DetailsPageControl.CloseBox();alert('提交成功');DetailsPageControl.ReflushList('ProductManage/GuanJiaoZhenImgManage.aspx');", true);
}
else if(num==0)
{
ScriptManager.RegisterStartupScript(Page, typeof(Page), "ListArea", "alert('提交失败');", true);
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="dtomodList">数据对象</param>
/// <returns></returns>
public static int Updatemod(GuanJiaoZhenImgMOD mod)
{
return GuanJiaoZhenImgDAO.Updatemod(mod);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="dtomodList">对象</param>
/// <returns></returns>
public static int Insertmod(GuanJiaoZhenImgMOD mod)
{
return GuanJiaoZhenImgDAO.Insertmod(mod);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="dtomodList">数据对象</param>
/// <returns></returns>
public static int Updatemod(GuanJiaoZhenImgMOD mod)
{
string sqlCommandString = "Update GuanJiaoZhenImg Set guanJiaoZhenImg=@guanJiaoZhenImg Where imgId=@imgId";
SqlParameter[] arParams = new SqlParameter[2];
arParams[0] = new SqlParameter("@imgId", mod.ImgId);
arParams[1] = new SqlParameter("@guanJiaoZhenImg", mod.GuanJiaoZhenImg);
return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlCommandString, arParams);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="dtomodList">对象</param>
/// <returns></returns>
public static int Insertmod(GuanJiaoZhenImgMOD mod)
{
string sqlCommandString = string.Format(
@"IF not exists(select 1 from GuanJiaoZhenImg where guanJiaoZhenNo='{0}')
BEGIN
Insert Into GuanJiaoZhenImg(guanJiaoZhenNo,guanJiaoZhenImg) Values (@guanJiaoZhenNo,@guanJiaoZhenImg)
END",mod.GuanJiaoZhenNo);
SqlParameter[] arParams = new SqlParameter[2];
arParams[0] = new SqlParameter("@guanJiaoZhenNo", mod.GuanJiaoZhenNo);
arParams[1] = new SqlParameter("@guanJiaoZhenImg", mod.GuanJiaoZhenImg);
return SqlHelper.ExecuteNonQuery(CommandType.Text, sqlCommandString, arParams);
}
