public HttpResponseMessage DeleteBasItemCategoryRow(dynamic obj)
{
int ItemType = (int)obj.ItemType;
if (ItemType == 2)
{
t_item_group itemGroup = new t_item_group()
{
ItemGroupID = obj.ItemGroupID
};
var result = new DBHelper <t_item_group>().Remove(itemGroup);
return(Json(true, result == 1 ? "删除成功！" : "删除失败"));
}
else
{
t_item_category itemCategory = new t_item_category()
{
ItemCategoryID = obj.ItemCategoryID
};
var result = new DBHelper <t_item_category>().Remove(itemCategory);
return(Json(true, result == 1 ? "删除成功！" : "删除失败"));
}
}
public HttpResponseMessage FindBasItemGroupCategoryForm(t_item_category obj)
{
var list = db.t_item_category.Where(w => w.IsValid != 0 && w.CorpID == userInfo.CorpID && w.ItemGroupID == obj.ItemGroupID).Select(s => new
{
label = s.Name,
value = s.ItemCategoryID
}).ToList();
return(Json(true, "", list));
}
public HttpResponseMessage SaveBasItemCategoryForm(t_item_category obj)
{
using (TransactionScope transaction = new TransactionScope())
{
DBHelper <t_item_category> dbhelp = new DBHelper <t_item_category>();
DateTime dt = DateTime.Now;
//事务
var result = 0;
var ItemCategory = db.t_item_category.Where(w => w.Code == obj.Code && w.CorpID == userInfo.CorpID);
try
{
if (obj.ItemCategoryID == 0)
{
string Code = "";
result = AutoIncrement.AutoIncrementResult("ItemCategory", out Code);
obj.CreateTime = dt;
obj.CreateUser = (int)userInfo.UserID;
obj.UPdateTime = dt;
obj.UpdateUser = (int)userInfo.UserID;
obj.CorpID = userInfo.CorpID;
obj.Code = Code;
if (ItemCategory.ToList().Count() > 0)
{
throw new Exception("编码重复！");
}
}
else
{
obj.UPdateTime = dt;
obj.UpdateUser = (int)userInfo.UserID;
if (ItemCategory.ToList().Count() > 1)
{
throw new Exception("编码重复！");
}
}
result = result + (obj.ItemCategoryID == 0 ? dbhelp.Add(obj) : dbhelp.Update(obj));
//提交事务
transaction.Complete();
return(Json(true, "保存成功！"));
}
catch (Exception ex)
{
return(Json(false, "保存失败！" + ex.Message));
}
}
}
