protected void imgbtnsure_Click(object sender, ImageClickEventArgs e)
{
int id = int.Parse(Request.Params["id"]);
EtNet_Models.PictureInfo model = EtNet_BLL.PictureInfoManager.GetModel(id);
if (model != null)
{
model.folderid = int.Parse(this.ddlfolder.SelectedValue);
model.cname = this.iptcname.Value;
if (this.radshare.SelectedValue == "0")
{
model.sharecode = 0;
model.sharestxt = "私有";
model.viewidlist = "";
model.viewtxtlist = "";
}
else
{
model.sharecode = 1;
model.sharestxt = "共享";
model.viewidlist = this.hidplist.Value;
model.viewtxtlist = this.iptplist.Value;
}
EtNet_BLL.PictureInfoManager.Update(model);
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "modify", "<script>alert('修改成功'); window.location = 'PictureShow.aspx';</script>");
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "modify", "<script>alert('修改失败,图片已删除');window.location = 'PictureShow.aspx'</script>");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public static bool Add(EtNet_Models.PictureInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PictureInfo(");
strSql.Append("cname,imgpath,size,format,createtime,modifytime,visiblecode,visibletxt,folderid,creater,sharecode,sharestxt,viewidlist,viewtxtlist,editidlist,edittxtlist,delidlist,deltxtlist)");
strSql.Append(" values (");
strSql.Append("@cname,@imgpath,@size,@format,@createtime,@modifytime,@visiblecode,@visibletxt,@folderid,@creater,@sharecode,@sharestxt,@viewidlist,@viewtxtlist,@editidlist,@edittxtlist,@delidlist,@deltxtlist)");
SqlParameter[] parameters =
{
new SqlParameter("@cname", SqlDbType.VarChar, 40),
new SqlParameter("@imgpath", SqlDbType.VarChar, 200),
new SqlParameter("@size", SqlDbType.Int, 4),
new SqlParameter("@format", SqlDbType.VarChar, 10),
new SqlParameter("@createtime", SqlDbType.DateTime),
new SqlParameter("@modifytime", SqlDbType.DateTime),
new SqlParameter("@visiblecode", SqlDbType.Int, 4),
new SqlParameter("@visibletxt", SqlDbType.VarChar, 10),
new SqlParameter("@folderid", SqlDbType.Int, 4),
new SqlParameter("@creater", SqlDbType.Int, 4),
new SqlParameter("@sharecode", SqlDbType.Int, 4),
new SqlParameter("@sharestxt", SqlDbType.VarChar, 10),
new SqlParameter("@viewidlist", SqlDbType.VarChar, 100),
new SqlParameter("@viewtxtlist", SqlDbType.VarChar, 400),
new SqlParameter("@editidlist", SqlDbType.VarChar, 100),
new SqlParameter("@edittxtlist", SqlDbType.VarChar, 400),
new SqlParameter("@delidlist", SqlDbType.VarChar, 100),
new SqlParameter("@deltxtlist", SqlDbType.VarChar, 400)
};
parameters[0].Value = model.cname;
parameters[1].Value = model.imgpath;
parameters[2].Value = model.size;
parameters[3].Value = model.format;
parameters[4].Value = model.createtime;
parameters[5].Value = model.modifytime;
parameters[6].Value = model.visiblecode;
parameters[7].Value = model.visibletxt;
parameters[8].Value = model.folderid;
parameters[9].Value = model.creater;
parameters[10].Value = model.sharecode;
parameters[11].Value = model.sharestxt;
parameters[12].Value = model.viewidlist;
parameters[13].Value = model.viewtxtlist;
parameters[14].Value = model.editidlist;
parameters[15].Value = model.edittxtlist;
parameters[16].Value = model.delidlist;
parameters[17].Value = model.deltxtlist;
int result = EtNet_DAL.DBHelper.ExecuteCommand(strSql.ToString(), parameters);
if (result >= 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 加载需修改的图片
/// </summary>
private void LoadPictureData()
{
if (Request.Params["id"] != "")
{
int id = int.Parse(Request.Params["id"]);
EtNet_Models.PictureInfo model = EtNet_BLL.PictureInfoManager.GetModel(id);
if (model != null)
{
this.iptcname.Value = model.cname;
this.ddlfolder.SelectedValue = model.folderid.ToString();
if (model.sharecode == 1)
{
this.radshare.Items[0].Selected = true;
this.iptplist.Value = model.viewtxtlist;
this.hidplist.Value = model.viewidlist;
}
else
{
this.radshare.Items[1].Selected = true;
}
}
else
{
this.imgbtnsure.Enabled = false;
}
}
}
/// <summary>
/// 删除图片文件
/// </summary>
private void DelFile(int id)
{
EtNet_Models.PictureInfo model = EtNet_BLL.PictureInfoManager.GetModel(id);
if (model != null && model.imgpath != "")
{
File.Delete(Server.MapPath(model.imgpath));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static EtNet_Models.PictureInfo GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,cname,imgpath,size,format,createtime,modifytime,visiblecode,visibletxt,folderid,creater,sharecode,sharestxt,viewidlist,viewtxtlist,editidlist,edittxtlist,delidlist,deltxtlist from PictureInfo ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
EtNet_Models.PictureInfo model = new EtNet_Models.PictureInfo();
DataTable tbl = EtNet_DAL.DBHelper.GetDataSet(strSql.ToString(), parameters);
if (tbl.Rows.Count > 0)
{
model.id = int.Parse(tbl.Rows[0]["id"].ToString());
model.cname = tbl.Rows[0]["cname"].ToString();
model.imgpath = tbl.Rows[0]["imgpath"].ToString();
model.size = int.Parse(tbl.Rows[0]["size"].ToString());
model.format = tbl.Rows[0]["format"].ToString();
model.createtime = DateTime.Parse(tbl.Rows[0]["createtime"].ToString());
model.modifytime = DateTime.Parse(tbl.Rows[0]["modifytime"].ToString());
model.visiblecode = int.Parse(tbl.Rows[0]["visiblecode"].ToString());
model.visibletxt = tbl.Rows[0]["visibletxt"].ToString();
model.folderid = int.Parse(tbl.Rows[0]["folderid"].ToString());
model.creater = int.Parse(tbl.Rows[0]["creater"].ToString());
model.sharecode = int.Parse(tbl.Rows[0]["sharecode"].ToString());
model.sharestxt = tbl.Rows[0]["sharestxt"].ToString();
model.viewidlist = tbl.Rows[0]["viewidlist"].ToString();
model.viewtxtlist = tbl.Rows[0]["viewtxtlist"].ToString();
model.editidlist = tbl.Rows[0]["editidlist"].ToString();
model.edittxtlist = tbl.Rows[0]["edittxtlist"].ToString();
model.delidlist = tbl.Rows[0]["delidlist"].ToString();
model.deltxtlist = tbl.Rows[0]["deltxtlist"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(EtNet_Models.PictureInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update PictureInfo set ");
strSql.Append("cname=@cname,");
strSql.Append("imgpath=@imgpath,");
strSql.Append("size=@size,");
strSql.Append("format=@format,");
strSql.Append("createtime=@createtime,");
strSql.Append("modifytime=@modifytime,");
strSql.Append("visiblecode=@visiblecode,");
strSql.Append("visibletxt=@visibletxt,");
strSql.Append("folderid=@folderid,");
strSql.Append("creater=@creater,");
strSql.Append("sharecode=@sharecode,");
strSql.Append("sharestxt=@sharestxt,");
strSql.Append("viewidlist=@viewidlist,");
strSql.Append("viewtxtlist=@viewtxtlist,");
strSql.Append("editidlist=@editidlist,");
strSql.Append("edittxtlist=@edittxtlist,");
strSql.Append("delidlist=@delidlist,");
strSql.Append("deltxtlist=@deltxtlist");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@cname", SqlDbType.VarChar, 40),
new SqlParameter("@imgpath", SqlDbType.VarChar, 200),
new SqlParameter("@size", SqlDbType.Int, 4),
new SqlParameter("@format", SqlDbType.VarChar, 10),
new SqlParameter("@createtime", SqlDbType.DateTime),
new SqlParameter("@modifytime", SqlDbType.DateTime),
new SqlParameter("@visiblecode", SqlDbType.Int, 4),
new SqlParameter("@visibletxt", SqlDbType.VarChar, 10),
new SqlParameter("@folderid", SqlDbType.Int, 4),
new SqlParameter("@creater", SqlDbType.Int, 4),
new SqlParameter("@sharecode", SqlDbType.Int, 4),
new SqlParameter("@sharestxt", SqlDbType.VarChar, 10),
new SqlParameter("@viewidlist", SqlDbType.VarChar, 100),
new SqlParameter("@viewtxtlist", SqlDbType.VarChar, 400),
new SqlParameter("@editidlist", SqlDbType.VarChar, 100),
new SqlParameter("@edittxtlist", SqlDbType.VarChar, 400),
new SqlParameter("@delidlist", SqlDbType.VarChar, 100),
new SqlParameter("@deltxtlist", SqlDbType.VarChar, 400),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.cname;
parameters[1].Value = model.imgpath;
parameters[2].Value = model.size;
parameters[3].Value = model.format;
parameters[4].Value = model.createtime;
parameters[5].Value = model.modifytime;
parameters[6].Value = model.visiblecode;
parameters[7].Value = model.visibletxt;
parameters[8].Value = model.folderid;
parameters[9].Value = model.creater;
parameters[10].Value = model.sharecode;
parameters[11].Value = model.sharestxt;
parameters[12].Value = model.viewidlist;
parameters[13].Value = model.viewtxtlist;
parameters[14].Value = model.editidlist;
parameters[15].Value = model.edittxtlist;
parameters[16].Value = model.delidlist;
parameters[17].Value = model.deltxtlist;
parameters[18].Value = model.id;
int result = EtNet_DAL.DBHelper.ExecuteCommand(strSql.ToString(), parameters);
if (result >= 1)
{
return(true);
}
else
{
return(false);
}
}
//保存上传的图片,提示是否上传成功
private void Save()
{
string saveurl = "../../UploadFile/Picture/";
string filename = "";
string newfile = "";
string format = "";
string result = "";
HttpPostedFile file = null;
EtNet_Models.PictureInfo model = null;
for (int i = 0; i < Request.Files.Count; i++)
{
file = Request.Files[i];
filename = file.FileName.Substring(file.FileName.LastIndexOf("\\") + 1);
if (file.FileName != "")
{
if (file.ContentLength <= (1024 * 1024))
{
format = file.FileName.Substring(file.FileName.LastIndexOf(".") + 1);
newfile = DateTime.Now.ToString("yyyyMMddHHmmss_ffff", DateTimeFormatInfo.InvariantInfo) + filename;
file.SaveAs(HttpContext.Current.Server.MapPath(saveurl + newfile));
model = new EtNet_Models.PictureInfo();
model.cname = filename;
model.creater = ((EtNet_Models.LoginInfo)Session["login"]).Id;
model.createtime = DateTime.Now;
model.delidlist = "";
model.deltxtlist = "";
model.editidlist = "";
model.edittxtlist = "";
model.folderid = int.Parse(this.ddlfolder.SelectedValue);
model.format = format;
model.imgpath = saveurl + newfile;
model.modifytime = DateTime.Now;
model.sharecode = 0;
model.sharestxt = "私有";
model.size = file.ContentLength;
model.viewidlist = "";
model.viewtxtlist = "";
model.visiblecode = 1;
model.visibletxt = "可见";
EtNet_BLL.PictureInfoManager.Add(model);
}
else
{
if (result == "")
{
result = filename;
}
else
{
result += "," + filename;
}
}
}
}
if (result == "")
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "add", "<script>alert('图片上传成功'); window.location = 'PictureShow.aspx'</script>", false);
}
else
{
result = "<script>alert('括号中的图片超出1M上传失败[" + result + "]')</script>";
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "add", result, false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(EtNet_Models.PictureInfo model)
{
return(EtNet_DAL.PictureInfoService.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public static bool Add(EtNet_Models.PictureInfo model)
{
return(EtNet_DAL.PictureInfoService.Add(model));
}
