//取类别ID
protected int GetCategoryTypeId(string name, DataTable dt)
{
foreach (DataRow dr in dt.Rows)
{
if (name == dr["CategoryTypeName"].ToString())
{
return(Int32.Parse(dr["CategoryTypeID"].ToString()));
}
}
UserCategoryEntity userCat = new UserCategoryEntity();
userCat.CategoryTypeName = name;
userCat.UserID = userId;
userCat.CategoryTypeLive = 1;
userCat.Synchronize = 1;
int catTypeId = 0;
bool success = UserCategoryAccess.InsertCategoryType(userCat, out catTypeId);
if (!success)
{
throw new Exception();
}
return(catTypeId);
}
//插入用户类别名称//输出类别ID用于数据导入时插入类别//
public static bool InsertCategoryType(UserCategoryEntity userCat, out int catTypeId)
{
DbCommand comm = GenericDataAccess.CreateCommand();
comm.CommandText = "InsertCategoryType_v4";
DbParameter param = comm.CreateParameter();
param.ParameterName = "@CategoryTypeName";
param.Value = userCat.CategoryTypeName;
param.DbType = DbType.String;
param.Size = 20;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@CategoryTypePrice";
param.Value = userCat.CategoryTypePrice;
param.DbType = DbType.Double;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserID";
param.Value = userCat.UserID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@CategoryTypeLive";
param.Value = userCat.CategoryTypeLive;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@Synchronize";
param.Value = userCat.Synchronize;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@CategoryTypeID";
param.Direction = ParameterDirection.Output;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
catTypeId = 0;
int result = -1;
try
{
result = GenericDataAccess.ExecuteNonQuery(comm);
catTypeId = Int32.Parse(comm.Parameters["@CategoryTypeID"].Value.ToString());
}
catch
{
}
return(catTypeId != 0);
}
//更新同步类别//
public static bool SyncCategoryUpdate(UserCategoryEntity userCat)
{
DbCommand comm = GenericDataAccess.CreateCommand();
comm.CommandText = "SyncCategoryUpdate_v4";
DbParameter param = comm.CreateParameter();
param.ParameterName = "@CategoryTypeID";
param.Value = userCat.CategoryTypeID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@CategoryTypeName";
param.Value = userCat.CategoryTypeName;
param.DbType = DbType.String;
param.Size = 20;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@CategoryTypePrice";
param.Value = userCat.CategoryTypePrice;
param.DbType = DbType.Double;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserID";
param.Value = userCat.UserID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@CategoryTypeLive";
param.Value = userCat.CategoryTypeLive;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@Synchronize";
param.Value = userCat.Synchronize;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
int result = -1;
try
{
result = GenericDataAccess.ExecuteNonQuery(comm);
}
catch
{
}
return(result != -1);
}
//删除用户类别名称//
public static bool DeleteCategoryType(UserCategoryEntity userCat)
{
DbCommand comm = GenericDataAccess.CreateCommand();
comm.CommandText = "DeleteCategoryType_v4";
DbParameter param = comm.CreateParameter();
param.ParameterName = "@CategoryTypeName";
param.Value = userCat.CategoryTypeName;
param.DbType = DbType.String;
param.Size = 20;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@CategoryTypePrice";
param.Value = userCat.CategoryTypePrice;
param.DbType = DbType.Double;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserID";
param.Value = userCat.UserID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@CategoryTypeID";
param.Value = userCat.CategoryTypeID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@CategoryTypeLive";
param.Value = userCat.CategoryTypeLive;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@Synchronize";
param.Value = userCat.Synchronize;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
int result = -1;
try
{
result = GenericDataAccess.ExecuteNonQuery(comm);
}
catch
{
}
return (result != -1);
}
protected void Page_Load(object sender, EventArgs e)
{
int catId = Int32.Parse(Request.Form["catid"].ToString());
string catName = Request.Form["catname"].ToString();
string catPrice = Request.Form["catprice"] ?? "";
int catLive = Int32.Parse(Request.Form["catlive"].ToString());
int userId = Int32.Parse(Request.Form["userid"].ToString());
UserCategoryEntity userCat = new UserCategoryEntity();
userCat.CategoryTypeID = catId;
userCat.CategoryTypeName = catName;
if (catPrice != "")
{
userCat.CategoryTypePrice = Double.Parse(catPrice);
}
userCat.UserID = userId;
userCat.CategoryTypeLive = catLive;
userCat.Synchronize = 0;
bool success = SyncHelper.SyncCheckCategoryIsExists(catId, userId);
if (success)
{
success = SyncHelper.SyncCategoryUpdate(userCat);
}
else
{
success = SyncHelper.SyncCategoryInsert(userCat);
}
string result = "{";
if (success)
{
result += "\"result\":\"ok\"";
}
else
{
result += "\"result\":\"error\"";
}
result += "}";
Response.Write(result);
Response.End();
}
//添加类别操作
protected void Button1_Click(object sender, EventArgs e)
{
string catTypeName = this.CatTypeNameEmpIns.Text.Trim();
if (catTypeName == "")
{
Utility.Alert(this, "类别名称未填写！");
return;
}
string catTypePrice = this.CatTypePriceEmpIns.Text.Trim();
if (catTypePrice != "")
{
if (!ValidHelper.CheckDouble(catTypePrice))
{
Utility.Alert(this, "类别预算填写错误！");
return;
}
}
else
{
catTypePrice = "0";
}
UserCategoryEntity userCat = new UserCategoryEntity();
userCat.CategoryTypeName = catTypeName;
userCat.CategoryTypePrice = Double.Parse(catTypePrice);
userCat.UserID = userId;
userCat.CategoryTypeLive = 1;
userCat.Synchronize = 1;
int catTypeId = 0;
bool success = UserCategoryAccess.InsertCategoryType(userCat, out catTypeId);
if (success)
{
Utility.Alert(this, "添加成功。", "UserCategoryAdmin.aspx");
}
else
{
Utility.Alert(this, "添加失败！");
}
}
//类别更新操作
protected void CatTypeList_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int catTypeId = Int32.Parse(CatTypeList.DataKeys[e.RowIndex].Value.ToString());
TextBox catTypeNameBox = (TextBox)CatTypeList.Rows[e.RowIndex].FindControl("CatTypeNameBox");
string catTypeName = catTypeNameBox.Text.Trim();
if (catTypeName == "")
{
Utility.Alert(this, "类别名称未填写！");
return;
}
TextBox catTypePriceBox = (TextBox)CatTypeList.Rows[e.RowIndex].FindControl("CatTypePriceBox");
string catTypePrice = catTypePriceBox.Text.Trim();
if (!ValidHelper.CheckDouble(catTypePrice))
{
Utility.Alert(this, "类别预算填写错误！");
return;
}
UserCategoryEntity userCat = new UserCategoryEntity();
userCat.CategoryTypeID = catTypeId;
userCat.CategoryTypeName = catTypeName;
userCat.CategoryTypePrice = Double.Parse(catTypePrice);
userCat.UserID = userId;
userCat.CategoryTypeLive = 1;
userCat.Synchronize = 1;
bool success = UserCategoryAccess.UpdateCategoryType(userCat);
if (success)
{
Utility.Alert(this, "更新成功。");
CatTypeList.EditIndex = -1;
BindGrid();
}
else
{
Utility.Alert(this, "更新失败！");
}
}
protected void Page_Load(object sender, EventArgs e)
{
int catId = Int32.Parse(Request.Form["catid"].ToString());
string catName = Request.Form["catname"].ToString();
string catPrice = Request.Form["catprice"] ?? "";
int catLive = Int32.Parse(Request.Form["catlive"].ToString());
int userId = Int32.Parse(Request.Form["userid"].ToString());
UserCategoryEntity userCat = new UserCategoryEntity();
userCat.CategoryTypeID = catId;
userCat.CategoryTypeName = catName;
if (catPrice != "") userCat.CategoryTypePrice = Double.Parse(catPrice);
userCat.UserID = userId;
userCat.CategoryTypeLive = catLive;
userCat.Synchronize = 0;
bool success = SyncHelper.SyncCheckCategoryIsExists(catId, userId);
if (success)
{
success = SyncHelper.SyncCategoryUpdate(userCat);
}
else
{
success = SyncHelper.SyncCategoryInsert(userCat);
}
string result = "{";
if (success)
{
result += "\"result\":\"ok\"";
}
else
{
result += "\"result\":\"error\"";
}
result += "}";
Response.Write(result);
Response.End();
}
//添加类别操作
protected void Button1_Click(object sender, EventArgs e)
{
string catTypeName = this.CatTypeNameEmpIns.Text.Trim();
if (catTypeName == "")
{
Utility.Alert(this, "类别名称未填写！");
return;
}
string catTypePrice = this.CatTypePriceEmpIns.Text.Trim();
if (catTypePrice != "")
{
if (!ValidHelper.CheckDouble(catTypePrice))
{
Utility.Alert(this, "类别预算填写错误！");
return;
}
}
else
{
catTypePrice = "0";
}
UserCategoryEntity userCat = new UserCategoryEntity();
userCat.CategoryTypeName = catTypeName;
userCat.CategoryTypePrice = Double.Parse(catTypePrice);
userCat.UserID = userId;
userCat.CategoryTypeLive = 1;
userCat.Synchronize = 1;
int catTypeId = 0;
bool success = UserCategoryAccess.InsertCategoryType(userCat, out catTypeId);
if (success)
{
Utility.Alert(this, "添加成功。", "UserCategoryAdmin.aspx");
}
else
{
Utility.Alert(this, "添加失败！");
}
}
//类别删除操作
protected void CatTypeList_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int catTypeId = Int32.Parse(CatTypeList.DataKeys[e.RowIndex].Value.ToString());
string catTypeName = ((Label)CatTypeList.Rows[e.RowIndex].FindControl("CatTypeNameLab")).Text;
string catTypePrice = ((Label)CatTypeList.Rows[e.RowIndex].FindControl("CatTypePriceLab")).Text;
UserCategoryEntity userCat = new UserCategoryEntity();
userCat.CategoryTypeID = catTypeId;
userCat.CategoryTypeName = catTypeName;
userCat.CategoryTypePrice = Double.Parse(catTypePrice);
userCat.UserID = userId;
userCat.CategoryTypeLive = 0;
userCat.Synchronize = 1;
bool success = UserCategoryAccess.CheckItemListByCatId(userId, catTypeId);
if (!success)
{
success = UserCategoryAccess.DeleteCategoryType(userCat);
if (success)
{
Utility.Alert(this, "删除成功。");
CatTypeList.EditIndex = -1;
BindGrid();
}
else
{
Utility.Alert(this, "删除失败！");
}
}
else
{
Utility.Alert(this, "不能删除已使用的类别！");
}
}
//类别删除操作
protected void CatTypeList_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int catTypeId = Int32.Parse(CatTypeList.DataKeys[e.RowIndex].Value.ToString());
string catTypeName = ((Label)CatTypeList.Rows[e.RowIndex].FindControl("CatTypeNameLab")).Text;
string catTypePrice = ((Label)CatTypeList.Rows[e.RowIndex].FindControl("CatTypePriceLab")).Text;
UserCategoryEntity userCat = new UserCategoryEntity();
userCat.CategoryTypeID = catTypeId;
userCat.CategoryTypeName = catTypeName;
userCat.CategoryTypePrice = Double.Parse(catTypePrice);
userCat.UserID = userId;
userCat.CategoryTypeLive = 0;
userCat.Synchronize = 1;
bool success = UserCategoryAccess.CheckItemListByCatId(userId, catTypeId);
if (!success)
{
success = UserCategoryAccess.DeleteCategoryType(userCat);
if (success)
{
Utility.Alert(this, "删除成功。");
CatTypeList.EditIndex = -1;
BindGrid();
}
else
{
Utility.Alert(this, "删除失败！");
}
}
else
{
Utility.Alert(this, "不能删除已使用的类别！");
}
}
//类别更新操作
protected void CatTypeList_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int catTypeId = Int32.Parse(CatTypeList.DataKeys[e.RowIndex].Value.ToString());
TextBox catTypeNameBox = (TextBox)CatTypeList.Rows[e.RowIndex].FindControl("CatTypeNameBox");
string catTypeName = catTypeNameBox.Text.Trim();
if (catTypeName == "")
{
Utility.Alert(this, "类别名称未填写！");
return;
}
TextBox catTypePriceBox = (TextBox)CatTypeList.Rows[e.RowIndex].FindControl("CatTypePriceBox");
string catTypePrice = catTypePriceBox.Text.Trim();
if (!ValidHelper.CheckDouble(catTypePrice))
{
Utility.Alert(this, "类别预算填写错误！");
return;
}
UserCategoryEntity userCat = new UserCategoryEntity();
userCat.CategoryTypeID = catTypeId;
userCat.CategoryTypeName = catTypeName;
userCat.CategoryTypePrice = Double.Parse(catTypePrice);
userCat.UserID = userId;
userCat.CategoryTypeLive = 1;
userCat.Synchronize = 1;
bool success = UserCategoryAccess.UpdateCategoryType(userCat);
if (success)
{
Utility.Alert(this, "更新成功。");
CatTypeList.EditIndex = -1;
BindGrid();
}
else
{
Utility.Alert(this, "更新失败！");
}
}
//取类别ID
protected int GetCategoryTypeId(string name, DataTable dt)
{
foreach (DataRow dr in dt.Rows)
{
if (name == dr["CategoryTypeName"].ToString())
{
return Int32.Parse(dr["CategoryTypeID"].ToString());
}
}
UserCategoryEntity userCat = new UserCategoryEntity();
userCat.CategoryTypeName = name;
userCat.UserID = userId;
userCat.CategoryTypeLive = 1;
userCat.Synchronize = 1;
int catTypeId = 0;
bool success = UserCategoryAccess.InsertCategoryType(userCat, out catTypeId);
if (!success)
{
throw new Exception();
}
return catTypeId;
}
//插入用户类别名称//输出类别ID用于数据导入时插入类别//
public static bool InsertCategoryType(UserCategoryEntity userCat, out int catTypeId)
{
DbCommand comm = GenericDataAccess.CreateCommand();
comm.CommandText = "InsertCategoryType_v4";
DbParameter param = comm.CreateParameter();
param.ParameterName = "@CategoryTypeName";
param.Value = userCat.CategoryTypeName;
param.DbType = DbType.String;
param.Size = 20;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@CategoryTypePrice";
param.Value = userCat.CategoryTypePrice;
param.DbType = DbType.Double;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserID";
param.Value = userCat.UserID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@CategoryTypeLive";
param.Value = userCat.CategoryTypeLive;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@Synchronize";
param.Value = userCat.Synchronize;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@CategoryTypeID";
param.Direction = ParameterDirection.Output;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
catTypeId = 0;
int result = -1;
try
{
result = GenericDataAccess.ExecuteNonQuery(comm);
catTypeId = Int32.Parse(comm.Parameters["@CategoryTypeID"].Value.ToString());
}
catch
{
}
return (catTypeId != 0);
}
