//取类别ID
private int GetCategoryTypeId(string catName)
{
catTypeList = cat_bll.GetUserCategoryList(userId);
foreach (DataRow dr in catTypeList.Rows)
{
if (catName == dr["CategoryTypeName"].ToString())
{
return(Convert.ToInt32(dr["CategoryTypeID"]));
}
}
UserCategoryInfo category = new UserCategoryInfo();
category.CategoryTypeID = cat_bll.GetMaxCategoryTypeId(userId);
category.CategoryTypeName = catName;
category.CategoryTypePrice = 0m;
category.UserID = userId;
category.CategoryTypeLive = 1;
category.Synchronize = 1;
category.ModifyDate = DateTime.Now;
bool success = cat_bll.InsertUserCategory(category);
if (success)
{
return(category.CategoryTypeID);
}
else
{
throw new Exception();
}
}
protected void Page_Load(object sender, EventArgs e)
{
int catId = Convert.ToInt32(Request.Form["catid"]);
string catName = Request.Form["catname"].ToString();
string catPrice = Request.Form["catprice"] ?? "";
byte catLive = Convert.ToByte(Request.Form["catlive"]);
int userId = Convert.ToInt32(Request.Form["userid"]);
UserCategoryInfo category = new UserCategoryInfo();
category.CategoryTypeID = catId;
category.CategoryTypeName = catName;
if (catPrice != "")
{
category.CategoryTypePrice = Convert.ToInt32(catPrice);
}
category.UserID = userId;
category.CategoryTypeLive = catLive;
category.Synchronize = 0;
bool success = bll.UserCategoryExistsWithSync(userId, catId);
if (success)
{
success = bll.UpdateUserCategory(category);
}
else
{
success = bll.InsertUserCategory(category);
}
string result = "{";
if (success)
{
result += "\"result\":\"ok\"";
}
else
{
result += "\"result\":\"error\"";
}
result += "}";
Response.Write(result);
Response.End();
}
//类别更新操作
protected void CatTypeList_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int catTypeId = Convert.ToInt32(CatTypeList.DataKeys[e.RowIndex].Value);
string catTypeName = ((TextBox)CatTypeList.Rows[e.RowIndex].FindControl("CatTypeNameBox")).Text.Trim();
string catTypeNameHid = ((HiddenField)CatTypeList.Rows[e.RowIndex].FindControl("CatTypeNameHid")).Value;
string catTypePrice = ((TextBox)CatTypeList.Rows[e.RowIndex].FindControl("CatTypePriceBox")).Text.Trim();
if (catTypeName == "")
{
Utility.Alert(this, "类别名称未填写！");
return;
}
if (catTypePrice != "")
{
if (!ValidHelper.CheckNumber(catTypePrice))
{
Utility.Alert(this, "类别预算填写错误！");
return;
}
}
else
{
catTypePrice = "0";
}
bool success = false;
UserCategoryInfo category = new UserCategoryInfo();
if (catTypeName != catTypeNameHid)
{
category = bll.GetUserCategoryByName(userId, catTypeName);
if (category.CategoryTypeID > 0)
{
Utility.Alert(this, "类别已存在，不能重复添加！");
return;
}
}
category.CategoryTypeID = catTypeId;
category.CategoryTypeName = catTypeName;
category.CategoryTypePrice = Convert.ToInt32(catTypePrice);
category.UserID = userId;
category.CategoryTypeLive = 1;
category.Synchronize = 1;
category.ModifyDate = DateTime.Now;
using (TransactionScope ts = new TransactionScope())
{
success = bll.DeleteUserCategory(userId, catTypeId);
success = bll.InsertUserCategory(category);
ts.Complete();
}
if (success)
{
CacheHelper.RemoveCache(string.Format("cattype_{0}", userId));
Utility.Alert(this, "更新成功。");
CatTypeList.EditIndex = -1;
BindGrid();
}
else
{
Utility.Alert(this, "更新失败！");
}
}