/// <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)); } } }