/// <summary>
/// 删除属性字段
/// </summary>
/// <param name="ENID"></param>
/// <returns></returns>
public ActionResult DelectGasisById(int ENID)
{
if (ENID > 0)
{
try
{
var listCheliang = (from tb in MyModels.B_BaseDetailList
where tb.BaseDetailID == ENID
select tb).Single();
B_BaseDetailList db = MyModels.B_BaseDetailList.Where(p => p.BaseDetailID == ENID).Single();
db.CancelBit = true;
MyModels.Entry(db).State = System.Data.Entity.EntityState.Modified;
MyModels.SaveChanges();
S_JournalList pwJournalTable = new S_JournalList();
pwJournalTable.usernameID = Convert.ToInt32(Session["usernameID"]);
pwJournalTable.Operate = "删除属性字段";
pwJournalTable.OperateDate = DateTime.Now;
MyModels.S_JournalList.Add(pwJournalTable);
MyModels.SaveChanges();
return(Json("success", JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json("Fail", JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("Fail", JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 修改数字能够字段
/// </summary>
/// <param name="Dropdown"></param>
/// <returns></returns>
public ActionResult UpdateXiaLa(B_BaseDetailList Dropdown)
{
string strMsg = "Fail";
try
{
var DropdownTypeid = Dropdown.BaseTypeID;
var list = (from tb in MyModels.B_BaseDetailList
where tb.BaseTypeID == DropdownTypeid
select new
{
tb.BaseDetailName,
}).ToList();
var dropdownDetailName = 0;
for (int i = 0; i < list.Count; i++)
{
if (Dropdown.BaseDetailName == list[i].BaseDetailName)
{
dropdownDetailName++;
}
}
if (dropdownDetailName > 0)
{
strMsg = "已存在";
}
else
{
MyModels.Entry(Dropdown).State = System.Data.Entity.EntityState.Modified;
MyModels.SaveChanges();
S_JournalList pwJournalTable = new S_JournalList();
pwJournalTable.usernameID = Convert.ToInt32(Session["usernameID"]);
pwJournalTable.Operate = "修改属性字段";
pwJournalTable.OperateDate = DateTime.Now;
MyModels.S_JournalList.Add(pwJournalTable);
MyModels.SaveChanges();
strMsg = "success";
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 新增属性字段
/// </summary>
/// <param name="ShuXing"></param>
/// <returns></returns>
public ActionResult InsertProperties(B_BaseDetailList Dropdown)
{
B_BaseDetailList dep = new B_BaseDetailList();
var T_DropdownDetail = Dropdown.BaseDetailID;
if (T_DropdownDetail == 0)
{
var DropdownTypeid = Dropdown.BaseTypeID;
var list = (from tb in MyModels.B_BaseDetailList
where tb.BaseTypeID == DropdownTypeid
select new
{
tb.BaseDetailName,
}).ToList();
var dropdownDetailName = 0;
for (int i = 0; i < list.Count; i++)
{
if (Dropdown.BaseDetailName == list[i].BaseDetailName)
{
dropdownDetailName++;
}
}
if (dropdownDetailName > 0)
{
return(Json("已存在", JsonRequestBehavior.AllowGet));
}
else
{
dep.BaseTypeID = Dropdown.BaseTypeID;
dep.BaseDetailName = Dropdown.BaseDetailName;
MyModels.B_BaseDetailList.Add(dep);
MyModels.SaveChanges();
S_JournalList pwJournalTable = new S_JournalList();
pwJournalTable.usernameID = Convert.ToInt32(Session["usernameID"]);
pwJournalTable.Operate = "新增属性字段";
pwJournalTable.OperateDate = DateTime.Now;
MyModels.S_JournalList.Add(pwJournalTable);
MyModels.SaveChanges();
return(Json("success", JsonRequestBehavior.AllowGet));
}
}
else
{
var DropdownTypeId = Dropdown.BaseTypeID;
var list = (from tb in MyModels.B_BaseDetailList
where tb.BaseTypeID == DropdownTypeId
select new
{
tb.BaseDetailName,
}).ToList();
var dropdownDetailNameT = 0;
for (int i = 0; i < list.Count; i++)
{
if (Dropdown.BaseDetailName == list[i].BaseDetailName)
{
dropdownDetailNameT++;
}
}
if (dropdownDetailNameT > 0)
{
return(Json("已存在", JsonRequestBehavior.AllowGet));
}
else
{
dep.BaseDetailID = Dropdown.BaseDetailID;
dep.BaseTypeID = Dropdown.BaseTypeID;
dep.BaseDetailName = Dropdown.BaseDetailName;
MyModels.B_BaseDetailList.Add(dep);
MyModels.SaveChanges();
S_JournalList pwJournalTable = new S_JournalList();
pwJournalTable.usernameID = Convert.ToInt32(Session["usernameID"]);
pwJournalTable.Operate = "新增基础数据";
pwJournalTable.OperateDate = DateTime.Now;
MyModels.S_JournalList.Add(pwJournalTable);
MyModels.SaveChanges();
return(Json("success", JsonRequestBehavior.AllowGet));
}
}
}
