/// <summary>
/// 删除物料类别
/// </summary>
private void DeletematerialCategory(HttpContext context)
{
//需要一个实体对象参数
//1,创建要删除的对象
Model.base_MaterialCategory mc = new Model.base_MaterialCategory()
{
ID = int.Parse(context.Request["ID"] + ""),//仓库ID
};
//2,将对象添加到EF管理容器中
db.base_MaterialCategory.Attach(mc);
//3,修改对象的包装类对象标识为删除状态
db.base_MaterialCategory.Remove(mc);
//4,更新到数据库
int num = db.SaveChanges();
context.Response.Write("{\"d\":" + num + "}");
}
/// <summary>
/// 编辑物料类别
/// </summary>
private void EditMaterialCategory(HttpContext context)
{
int ID = int.Parse(context.Request["ID"] + "");//仓库ID
string CategoryName = context.Request["CategoryName"] + "";
string ParentName = context.Request["ParentName"] + "";
Model.base_MaterialCategory mc = new Model.base_MaterialCategory()
{
ID = ID,
CategoryName= CategoryName,
Status = 1,//状态
LastUpdateBy = UserInfo.UserName,//编辑人
LastUpdateTime = DateTime.Now//编辑时间
};
//如果输入上一级不为空，填充ParentID
if (!string.IsNullOrEmpty(ParentName.Trim()))
{
List<Model.base_MaterialCategory> list = db.base_MaterialCategory.Where(w => w.CategoryName == ParentName).Select(s => s).ToList();
if (list.Count == 0)
{
var obj = new { d = 0, msg = "上一级输入错误，不存在！" };
context.Response.Write(JsonConvert.SerializeObject(obj));
return;
}
else
{
mc.ParentID = list[0].ID;
mc.ParentName = ParentName;
}
}
//先将实体附加到实体上下文中
db.base_MaterialCategory.Attach(mc);
//手动修改实体的状态
db.Entry(mc).State = EntityState.Modified;
int num = db.SaveChanges();
context.Response.Write("{\"d\":" + num + "}");
}
/// <summary>
/// 添加物料分类
/// </summary>
private void AddMaterialCategory(HttpContext context)
{
string CategoryName = context.Request["CategoryName"] + "";
string ParentName = context.Request["ParentName"]+"";
Model.base_MaterialCategory mCategory = new Model.base_MaterialCategory() {
CategoryName = CategoryName,//分类名称
Status = 1,//状态
AddBy = UserInfo.UserName,//添加人
AddTime = DateTime.Now//添加时间
};
//如果输入上一级不为空，填充ParentID
if (!string.IsNullOrEmpty(ParentName.Trim()))
{
List<Model.base_MaterialCategory> list = db.base_MaterialCategory.Where(w => w.CategoryName == ParentName).Select(s => s).ToList();
if (list.Count==0)
{
var obj = new {d=0,msg="上一级输入错误，不存在！" };
context.Response.Write(JsonConvert.SerializeObject(obj));
return;
}
else
{
mCategory.ParentID = list[0].ID;
mCategory.ParentName = ParentName;
}
}
//录入数据库
db.base_MaterialCategory.Add(mCategory);
int num = db.SaveChanges();
context.Response.Write("{\"d\":" + num + "}");
}
