//新增
protected void imgbtnadd_Click(object sender, ImageClickEventArgs e)
{
string strsql = " creater=" + ((EtNet_Models.LoginInfo)Session["login"]).Id;
strsql += " AND cname='" + this.hidtxt.Value + "'";
DataTable tbl = EtNet_BLL.PictureFolderInfoManager.GetList(strsql);
if (tbl.Rows.Count == 0)
{
EtNet_Models.PictureFolderInfo model = new EtNet_Models.PictureFolderInfo();
model.capacity = 10;
model.capacityused = 10;
model.cname = this.hidtxt.Value;
model.creater = ((EtNet_Models.LoginInfo)Session["login"]).Id;
model.typecode = 1;
model.typetxt = "个人图库";
model.upid = 0;
if (EtNet_BLL.PictureFolderInfoManager.Add(model))
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "add", "<script>alert('添加成功')</script>", false);
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "add", "<script>alert('添加失败')</script>", false);
}
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "add", "<script>alert('添加失败,该名称已存在')</script>", false);
}
this.hidsel.Value = "";
this.hidtxt.Value = "";
LoadPictureFolder();
}
//修改
protected void imgbtnedit_Click(object sender, ImageClickEventArgs e)
{
string strsql = " creater=" + ((EtNet_Models.LoginInfo)Session["login"]).Id;
strsql += " AND cname='" + this.hidtxt.Value + "' AND id not in(" + this.hidsel.Value + ")";
DataTable tbl = EtNet_BLL.PictureFolderInfoManager.GetList(strsql);
if (tbl.Rows.Count == 0)
{
int id = int.Parse(this.hidsel.Value);
EtNet_Models.PictureFolderInfo model = EtNet_BLL.PictureFolderInfoManager.GetModel(id);
model.cname = this.hidtxt.Value;
if (EtNet_BLL.PictureFolderInfoManager.Update(model))
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "add", "<script>alert('修改成功')</script>", false);
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "add", "<script>alert('修改失败')</script>", false);
}
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "add", "<script>alert('修改失败,该名称已存在')</script>", false);
}
this.hidsel.Value = "";
this.hidtxt.Value = "";
LoadPictureFolder();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static EtNet_Models.PictureFolderInfo GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from PictureFolderInfo ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
EtNet_Models.PictureFolderInfo model = new EtNet_Models.PictureFolderInfo();
DataTable tbl = EtNet_DAL.DBHelper.GetDataSet(strSql.ToString(), parameters);
if (tbl.Rows.Count > 0)
{
model.id = int.Parse(tbl.Rows[0]["id"].ToString());
model.upid = int.Parse(tbl.Rows[0]["upid"].ToString());
model.cname = tbl.Rows[0]["cname"].ToString();
model.capacity = int.Parse(tbl.Rows[0]["capacity"].ToString());
model.capacityused = int.Parse(tbl.Rows[0]["capacityused"].ToString());
model.typecode = int.Parse(tbl.Rows[0]["typecode"].ToString());
model.typetxt = tbl.Rows[0]["typetxt"].ToString();
model.creater = int.Parse(tbl.Rows[0]["creater"].ToString());
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(EtNet_Models.PictureFolderInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update PictureFolderInfo set ");
strSql.Append("upid=@upid,");
strSql.Append("cname=@cname,");
strSql.Append("capacity=@capacity,");
strSql.Append("capacityused=@capacityused,");
strSql.Append("typecode=@typecode,");
strSql.Append("typetxt=@typetxt,");
strSql.Append("creater=@creater");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@upid", SqlDbType.Int, 4),
new SqlParameter("@cname", SqlDbType.VarChar, 40),
new SqlParameter("@capacity", SqlDbType.Int, 4),
new SqlParameter("@capacityused", SqlDbType.Int, 4),
new SqlParameter("@typecode", SqlDbType.Int, 4),
new SqlParameter("@typetxt", SqlDbType.VarChar, 40),
new SqlParameter("@creater", SqlDbType.Int, 4),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.upid;
parameters[1].Value = model.cname;
parameters[2].Value = model.capacity;
parameters[3].Value = model.capacityused;
parameters[4].Value = model.typecode;
parameters[5].Value = model.typetxt;
parameters[6].Value = model.creater;
parameters[7].Value = model.id;
int result = EtNet_DAL.DBHelper.ExecuteCommand(strSql.ToString(), parameters);
if (result >= 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public static bool Add(EtNet_Models.PictureFolderInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PictureFolderInfo(");
strSql.Append("upid,cname,capacity,capacityused,typecode,typetxt,creater)");
strSql.Append(" values (");
strSql.Append("@upid,@cname,@capacity,@capacityused,@typecode,@typetxt,@creater)");
SqlParameter[] parameters =
{
new SqlParameter("@upid", SqlDbType.Int, 4),
new SqlParameter("@cname", SqlDbType.VarChar, 40),
new SqlParameter("@capacity", SqlDbType.Int, 4),
new SqlParameter("@capacityused", SqlDbType.Int, 4),
new SqlParameter("@typecode", SqlDbType.Int, 4),
new SqlParameter("@typetxt", SqlDbType.VarChar, 40),
new SqlParameter("@creater", SqlDbType.Int, 4)
};
parameters[0].Value = model.upid;
parameters[1].Value = model.cname;
parameters[2].Value = model.capacity;
parameters[3].Value = model.capacityused;
parameters[4].Value = model.typecode;
parameters[5].Value = model.typetxt;
parameters[6].Value = model.creater;
int result = EtNet_DAL.DBHelper.ExecuteCommand(strSql.ToString(), parameters);
if (result >= 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(EtNet_Models.PictureFolderInfo model)
{
return(EtNet_DAL.PictureFolderInfoService.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public static bool Add(EtNet_Models.PictureFolderInfo model)
{
return(EtNet_DAL.PictureFolderInfoService.Add(model));
}
