//读取产品名称与型号列表 public ActionResult GetChanPinList() { var tmc = T_ChanPinNameService.LoadEntities(x => x.Del == 0); var tempName = from a in tmc where a.MyColums == "CPname" select new { ID = a.ID, MyText = a.MyTexts, MyColums = a.MyColums }; var tempXingH = from a in tmc where a.MyColums == "CPxinghao" select new { ID = a.ID, MyText = a.MyTexts, MyColums = a.MyColums }; var tempDengji = from a in tmc where a.MyColums == "CPDengJi" select new { ID = a.ID, MyText = a.MyTexts, MyColums = a.MyColums }; tempName = tempName.OrderBy(p => p.MyText); tempXingH = tempXingH.OrderBy(p => p.MyText); tempDengji = tempDengji.OrderBy(p => p.MyText); return(Json(new { tempName = tempName, tempXingH = tempXingH, tempDengji = tempDengji, ret = "ok" }, JsonRequestBehavior.AllowGet)); }
//复杂查询 //获取产品名称 public ActionResult GetCPname() { int action = int.Parse(Request["Action"]); var tmc = T_ChanPinNameService.LoadEntities(x => x.Del == 0); var tempName = from a in tmc where a.MyColums == "CPname" select new { ID = a.ID, MyText = a.MyTexts, MyColums = a.MyColums }; var tempXingH = from a in tmc where a.MyColums == "CPxinghao" select new { ID = a.ID, MyText = a.MyTexts, MyColums = a.MyColums }; tempName = tempName.OrderBy(p => p.MyText); tempXingH = tempXingH.OrderBy(p => p.MyText); return(Json(action == 1?tempName:tempXingH, JsonRequestBehavior.AllowGet)); }
//获取产品级别 public ActionResult GetCPJBList() { var temp = T_ChanPinNameService.LoadEntities(x => x.MyColums == "CPDengJi").DefaultIfEmpty(); var rtmp = from a in temp select new { ID = a.ID, MyTexts = a.MyTexts }; return(Json(rtmp, JsonRequestBehavior.AllowGet)); }
//获取产品型号 public ActionResult GetBCPXHList() { long id = Convert.ToInt64(Request["id"]); var temp = T_ChanPinNameService.LoadEntities(x => x.ID == id).FirstOrDefault(); var tem = from a in temp.YXB_WinCanPin.DefaultIfEmpty() select new { ID = a.T_ChanPinName1.ID, MyTexts = a.T_ChanPinName1.MyTexts }; return(Json(tem, JsonRequestBehavior.AllowGet)); }
//删除产品 信息 public ActionResult DelChanPin() { long delID = Convert.ToInt64(Request["delID"]); var NameOrType = Request["bol"]; if (NameOrType == "true") { var deldata = T_ChanPinNameService.LoadEntities(x => x.ID == delID).FirstOrDefault(); if (deldata.CreatePerson != LoginUser.ID) { return(Json("noperson", JsonRequestBehavior.AllowGet)); } else { deldata.Del = 1; if (T_ChanPinNameService.EditEntity(deldata)) { return(Json("ok", JsonRequestBehavior.AllowGet)); } else { return(Json("no", JsonRequestBehavior.AllowGet)); } } } else if (NameOrType == "false") { var deldata = YXB_WinCanPinService.LoadEntities(x => x.ID == delID).FirstOrDefault(); if (deldata.T_ChanPinName.CreatePerson != LoginUser.ID) { return(Json("noperson", JsonRequestBehavior.AllowGet)); } else { deldata.Del = 1; if (YXB_WinCanPinService.EditEntity(deldata)) { return(Json("ok", JsonRequestBehavior.AllowGet)); } else { return(Json("no", JsonRequestBehavior.AllowGet)); } } } else { return(Json("no", JsonRequestBehavior.AllowGet)); } }
//创建产品型号与名称 public ActionResult ADDxinghaoName( ) { string cpname = Request["Name"]; var Seltcp = T_ChanPinNameService.LoadEntities(x => x.MyTexts == cpname).FirstOrDefault(); if (Seltcp == null) { T_ChanPinName Tcp = new T_ChanPinName(); Tcp.MyColums = Request["MyColums"]; Tcp.MyTexts = Request["Name"]; Tcp.CreatePerson = LoginUser.ID; Tcp.CreateTime = MvcApplication.GetT_time(); Tcp.Del = 0; T_ChanPinNameService.AddEntity(Tcp); return(Json("ok", JsonRequestBehavior.AllowGet)); } else { return(Json("Isdistict", JsonRequestBehavior.AllowGet)); } }
//读取产品名称与型号列表 public ActionResult GetChanPinList() { #region MyRegion ////isSale==1是产品 0是运费 //TModel.DAL.AA_InventoryDal Tda = new TModel.DAL.AA_InventoryDal(); //var tempCp = Tda.LoadEntities(x => x.idwarehouse == 5 && x.isSale == 1).DefaultIfEmpty(); //List<Inventory> Liy = new List<Inventory>(); //foreach (var a in tempCp) //{ // Inventory ity = new Inventory(); // ity.ID = a.id; // ity.code = a.code; // ity.Name = a.name; // ity.XingH = a.specification; // ity.shorthand = a.shorthand; // Liy.Add(ity); //} //var DitName = Liy.GroupBy(x => x.Name).Where(g => g.Count() > 1).ToList(); //List<MoedName> lmn = new List<MoedName>(); //foreach (var aa in DitName) //{ // MoedName mn = new MoedName(); // mn.MyColums = aa.Key; // mn.MyText = aa.Key; // lmn.Add(mn); //} //var tempName = lmn; #endregion var tmc = T_ChanPinNameService.LoadEntities(x => x.Del == 0).DefaultIfEmpty(); var tempName = from a in tmc where a.MyColums == "CPname" select new { ID = a.ID, MyText = a.MyTexts, MyColums = a.MyColums }; var tempXingH = from a in tmc where a.MyColums == "CPxinghao" select new { ID = a.ID, MyText = a.MyTexts, MyColums = a.MyColums }; var tempDengji = from a in tmc where a.MyColums == "CPDengJi" select new { ID = a.ID, MyText = a.MyTexts, MyColums = a.MyColums }; tempXingH = tempXingH.OrderBy(p => p.MyText); tempName = tempName.OrderBy(p => p.MyText); tempDengji = tempDengji.OrderBy(p => p.MyText); return(Json(new { tempName = tempName, tempXingH = tempXingH, tempDengji = tempDengji, ret = "ok" }, JsonRequestBehavior.AllowGet)); }