/// <summary>
/// 插入专题
/// </summary>
public bool InsertZhuanTi(ZhuanTiInfo zhuanTi)
{
SqlParameter[] parms = ModelToParms(zhuanTi);
int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString, CommandType.StoredProcedure, SQL_INSERT_ZHUANTI, parms);
return(result > 0);
}
//更新操作
protected void List_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int ztId = Convert.ToInt32(List.DataKeys[e.RowIndex].Value);
string zhuanTiImage = ((HiddenField)List.Rows[e.RowIndex].FindControl("ZhuanTiImageHid")).Value;
string zhuanTiName = ((TextBox)List.Rows[e.RowIndex].FindControl("ZhuanTiNameBox")).Text.Trim();
string zhuanTiNameHid = ((HiddenField)List.Rows[e.RowIndex].FindControl("ZhuanTiNameHid")).Value;
FileUpload zhuanTiImageUpload = (FileUpload)List.Rows[e.RowIndex].FindControl("ZhuanTiImageUpload");
if (zhuanTiImageUpload.HasFile)
{
zhuanTiImage = SaveZhuanTiImage(zhuanTiImageUpload, zhuanTiImage, ztId);
if (zhuanTiImage == "")
{
return;
}
}
if (zhuanTiName == "")
{
Utility.Alert(this, "专题名称未填写！");
return;
}
ZhuanTiInfo zhuanTi = new ZhuanTiInfo();
if (zhuanTiName != zhuanTiNameHid)
{
zhuanTi = bll.GetZhuanTiByZhuanTiName(userId, zhuanTiName);
if (zhuanTi.ZhuanTiID > 0)
{
Utility.Alert(this, "专题已存在，不能重复添加！");
return;
}
}
zhuanTi.ZhuanTiImage = zhuanTiImage;
zhuanTi.ZhuanTiName = zhuanTiName;
zhuanTi.UserID = userId;
zhuanTi.ModifyDate = DateTime.Now;
zhuanTi.Synchronize = 1;
zhuanTi.ZTID = ztId;
bool success = bll.UpdateZhuanTi(zhuanTi);
if (success)
{
CacheHelper.RemoveCache(string.Format("zttype_{0}", userId));
Utility.Alert(this, "更新成功。");
List.EditIndex = -1;
BindGrid();
}
else
{
Utility.Alert(this, "更新失败！");
}
}
//添加操作
protected void Button1_Click(object sender, EventArgs e)
{
int ztId = bll.GetMaxZhuanTiId(userId);
string zhuanTiImage = "";
string zhuanTiName = this.ZhuanTiNameIns.Text.Trim();
if (this.ZhuanTiImageIns.HasFile)
{
zhuanTiImage = SaveZhuanTiImage(this.ZhuanTiImageIns, zhuanTiImage, ztId);
if (zhuanTiImage == "")
{
return;
}
}
else
{
Utility.Alert(this, "专题图片未选择！");
return;
}
if (zhuanTiName == "")
{
Utility.Alert(this, "专题名称未填写！");
return;
}
ZhuanTiInfo zhuanTi = bll.GetZhuanTiByZhuanTiName(userId, zhuanTiName);
zhuanTi.ZhuanTiName = zhuanTiName;
zhuanTi.ZhuanTiImage = zhuanTiImage;
zhuanTi.ZhuanTiLive = 1;
zhuanTi.Synchronize = 1;
zhuanTi.UserID = userId;
zhuanTi.ModifyDate = DateTime.Now;
zhuanTi.ZTID = ztId;
if (zhuanTi.ZhuanTiID > 0)
{
Utility.Alert(this, "专题已存在，不能重复添加！");
return;
}
bool success = bll.InsertZhuanTi(zhuanTi);
if (success)
{
Utility.Alert(this, "添加成功。", "UserZhuanTi.aspx");
}
else
{
Utility.Alert(this, "添加失败！");
}
}
protected void Page_Load(object sender, EventArgs e)
{
int ztId = Convert.ToInt32(Request.Form["ztid"]);
string ztName = Request.Form["ztname"].ToString();
string ztImage = Request.Form["ztimage"].ToString();
byte ztLive = Convert.ToByte(Request.Form["ztlive"]);
int userId = Convert.ToInt32(Request.Form["userid"]);
ZhuanTiInfo zhuanTi = bll.GetZhuanTiByZhuanTiId(userId, ztId);
zhuanTi.ZTID = ztId;
zhuanTi.ZhuanTiName = ztName;
zhuanTi.ZhuanTiImage = ztImage;
zhuanTi.UserID = userId;
zhuanTi.ZhuanTiLive = ztLive;
zhuanTi.Synchronize = 0;
zhuanTi.ModifyDate = DateTime.Now;
bool success = false;
if (zhuanTi.ZhuanTiID == 0)
{
success = bll.InsertZhuanTi(zhuanTi);
}
else
{
success = bll.UpdateZhuanTi(zhuanTi);
}
string result = "{";
if (success)
{
result += "\"result\":\"ok\"";
}
else
{
result += "\"result\":\"error\"";
}
result += "}";
Response.Write(result);
Response.End();
}
/// <summary>
/// 数据转专题实体
/// </summary>
public static ZhuanTiInfo DataToModel(SqlDataReader rdr)
{
ZhuanTiInfo zhuanTi = new ZhuanTiInfo();
if (!rdr.IsDBNull(0))
{
zhuanTi.ZhuanTiID = rdr.GetInt32(0);
}
if (!rdr.IsDBNull(1))
{
zhuanTi.ZhuanTiName = rdr.GetString(1);
}
if (!rdr.IsDBNull(2))
{
zhuanTi.ZhuanTiImage = rdr.GetString(2);
}
if (!rdr.IsDBNull(3))
{
zhuanTi.UserID = rdr.GetInt32(3);
}
if (!rdr.IsDBNull(4))
{
zhuanTi.ZhuanTiLive = rdr.GetByte(4);
}
if (!rdr.IsDBNull(5))
{
zhuanTi.Synchronize = rdr.GetByte(5);
}
if (!rdr.IsDBNull(6))
{
zhuanTi.ModifyDate = rdr.GetDateTime(6);
}
if (!rdr.IsDBNull(7))
{
zhuanTi.ZTID = rdr.GetInt32(7);
}
return(zhuanTi);
}
/// <summary>
/// 根据专题名称取专题
/// </summary>
public ZhuanTiInfo GetZhuanTiByZhuanTiName(int userId, string zhuanTiName)
{
ZhuanTiInfo zhuanTi = new ZhuanTiInfo();
SqlParameter[] parms =
{
new SqlParameter(PARM_USER_ID, SqlDbType.Int),
new SqlParameter(PARM_ZHUANTI_NAME, SqlDbType.NVarChar, 20)
};
parms[0].Value = userId;
parms[1].Value = zhuanTiName;
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.Text, SQL_SELECT_ZHUANTI_BY_ZHUANTI_NAME, parms))
{
while (rdr.Read())
{
zhuanTi = DataToModel(rdr);
}
}
return(zhuanTi);
}
//取专题ID
private int?GetZhuanTiId(string zhuanTiName)
{
if (zhuanTiName == "")
{
return(0);
}
zhuanTiList = zt_bll.GetZhuanTiList(userId);
foreach (DataRow dr in zhuanTiList.Rows)
{
if (zhuanTiName == dr["ZhuanTiName"].ToString())
{
return(Convert.ToInt32(dr["ZTID"]));
}
}
ZhuanTiInfo zhuanTi = new ZhuanTiInfo();
zhuanTi.ZhuanTiName = zhuanTiName;
zhuanTi.ZhuanTiLive = 1;
zhuanTi.Synchronize = 1;
zhuanTi.UserID = userId;
zhuanTi.ModifyDate = DateTime.Now;
zhuanTi.ZTID = zt_bll.GetMaxZhuanTiId(userId);
bool success = zt_bll.InsertZhuanTi(zhuanTi);
if (success)
{
return(zhuanTi.ZTID);
}
else
{
throw new Exception();
}
}
/// <summary>
/// 专题实体转参数
/// </summary>
public static SqlParameter[] ModelToParms(ZhuanTiInfo zhuanTi)
{
SqlParameter[] parms =
{
new SqlParameter("@ZhuanTiID", SqlDbType.Int),
new SqlParameter("@ZhuanTiName", SqlDbType.NVarChar, 20),
new SqlParameter("@ZhuanTiImage", SqlDbType.NVarChar, 200),
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@ZhuanTiLive", SqlDbType.TinyInt),
new SqlParameter("@Synchronize", SqlDbType.TinyInt),
new SqlParameter("@ModifyDate", SqlDbType.DateTime),
new SqlParameter("@ZTID", SqlDbType.Int)
};
parms[0].Value = zhuanTi.ZhuanTiID;
parms[1].Value = zhuanTi.ZhuanTiName;
parms[2].Value = zhuanTi.ZhuanTiImage;
parms[3].Value = zhuanTi.UserID;
parms[4].Value = zhuanTi.ZhuanTiLive;
parms[5].Value = zhuanTi.Synchronize;
parms[6].Value = zhuanTi.ModifyDate;
parms[7].Value = zhuanTi.ZTID;
return(parms);
}
//删除操作
protected void List_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int ztId = Convert.ToInt32(List.DataKeys[e.RowIndex].Value);
string zhuanTiImage = ((HiddenField)List.Rows[e.RowIndex].FindControl("ZhuanTiImageHid")).Value;
ZhuanTiInfo zhuanTi = bll.GetZhuanTiByZhuanTiId(userId, ztId);
zhuanTi.ZhuanTiLive = 0;
zhuanTi.Synchronize = 1;
zhuanTi.ModifyDate = DateTime.Now;
using (TransactionScope ts = new TransactionScope())
{
bool success = false;
DataTable lists = item_bll.GetItemListAllByZhuanTiId(userId, ztId);
if (lists.Rows.Count > 0)
{
foreach (DataRow dr in lists.Rows)
{
int itemId = Convert.ToInt32(dr["ItemID"]);
int itemAppId = Convert.ToInt32(dr["ItemAppID"]);
success = item_bll.DeleteItem(userId, itemId, itemAppId);
if (!success)
{
break;
}
}
}
else
{
success = true;
}
if (success)
{
success = bll.UpdateZhuanTi(zhuanTi);
}
else
{
Utility.Alert(this, "消费删除失败！");
return;
}
if (success)
{
Utility.Alert(this, "删除成功。");
List.EditIndex = -1;
BindGrid();
}
else
{
Utility.Alert(this, "专题删除失败！");
}
ts.Complete();
}
//删除专题图片
if (ImageHelper.CanDelete(zhuanTiImage))
{
try
{
ImageHelper.DeleteZhuanTiImage(zhuanTiImage);
}
catch { }
}
}
/// <summary>
/// 修改专题
/// </summary>
public bool UpdateZhuanTi(ZhuanTiInfo zhuanTi)
{
return(dal.UpdateZhuanTi(zhuanTi));
}
/// <summary>
/// 插入专题
/// </summary>
public bool InsertZhuanTi(ZhuanTiInfo zhuanTi)
{
return(dal.InsertZhuanTi(zhuanTi));
}
