public ActionResult Users() { token = appClass.CRM_Gettoken(); CRM_HG_STAFFKHLX[] data = crmModels.HG_STAFFKHLX.Read(token); ViewData.Model = data; return(View()); }
public string GET_TMINFO(string datastring) { string token = appClass.CRM_Gettoken(); MES_TM_TMINFO model_MES_TM_TMINFO = Newtonsoft.Json.JsonConvert.DeserializeObject <MES_TM_TMINFO>(datastring); model_MES_TM_TMINFO.TMLB = 1; SELECT_MES_TM_TMINFO_BYTM rst_SELECT_MES_TM_TMINFO_BYTM = mesModels.TM_TMINFO.SELECT(model_MES_TM_TMINFO, token); return(Newtonsoft.Json.JsonConvert.SerializeObject(rst_SELECT_MES_TM_TMINFO_BYTM)); }
public int Insert_Wl(string data) { token = appClass.CRM_Gettoken(); CRM_WL_TT model = JsonConvert.DeserializeObject <CRM_WL_TT>(data); model.ISACTIVE = 1; int i = crmModels.WL_TT.Create(model, token); return(i); }
public ActionResult CODING() { Session["location"] = 11003; token = appClass.CRM_Gettoken(); CRM_HG_DICT[] DATA = crmModels.HG_DICT.Read(128, 0, token); ViewBag.DATA = DATA; ViewBag.START = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd"); ViewBag.END = DateTime.Now.ToString("yyyy-MM-dd"); ViewBag.RemoteAddress = RemoteAddress; return(View()); }
public string GetData_Wl(string cxdata) { token = appClass.CRM_Gettoken(); CRM_WL_TT model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_WL_TT>(cxdata); CRM_WL_TT[] data = crmModels.WL_TT.ReadByParam(model, token); return(Newtonsoft.Json.JsonConvert.SerializeObject(data)); }
public ActionResult CK_Setting() { Session["location"] = 20000; token = appClass.CRM_Gettoken(); MES_SY_TYPEMX cx_ljxt = new MES_SY_TYPEMX(); cx_ljxt.TYPEID = 39; MES_SY_TYPEMXLIST[] LJXT = mesModels.SY_TYPEMX.SELECT(cx_ljxt, token); ViewBag.LJXT = LJXT; MES_SY_GC cx_gc = new MES_SY_GC(); cx_gc.STAFFID = appClass.CRM_GetStaffid(); MES_SY_GC[] GC = mesModels.SY_GC.SELECT_BY_ROLE(cx_gc, token); ViewBag.GC = GC; return(View()); }
public string SY_DICT_Read(string data) { token = appClass.CRM_Gettoken(); FIVES_SY_DICT model = Newtonsoft.Json.JsonConvert.DeserializeObject <FIVES_SY_DICT>(data); FIVES_SY_DICT[] res = fivesmodels.SY_DICT.Read(model, token); //HR_SY_DEPT_SELECT r = hrmodels.SY_DEPT.SELECT(new HR_SY_DEPT(), token); return(Newtonsoft.Json.JsonConvert.SerializeObject(res)); }
public ActionResult Show_Notice(int NOTICETTID) { token = appClass.CRM_Gettoken(); CRM_MSG_NOTICETTList TTdata = crmModels.MSG_NOTICE.ReadTTbyTTID(NOTICETTID, token); CRM_HG_WJJL[] FJdata = crmModels.HG_WJJL.Read(12, NOTICETTID, token); string netpath = System.Configuration.ConfigurationManager.AppSettings["NETPATH"]; for (int i = 0; i < FJdata.Length; i++) { if (FJdata[i].ML != "") { string[] p = FJdata[i].ML.Split('\\'); int count = p.Length - 1; string path = p[count - 2] + @"/" + p[count - 1] + @"/" + p[count]; FJdata[i].ML = netpath + path; } } ViewBag.FJdata = FJdata; ViewBag.TTdata = TTdata; return(View()); }
public ActionResult TMPrint_GL() { Session["location"] = 21001; token = appClass.CRM_Gettoken(); MES_SY_TYPEMX cx_ljxt = new MES_SY_TYPEMX(); cx_ljxt.TYPEID = 43; MES_SY_TYPEMXLIST[] TYPE = mesModels.SY_TYPEMX.SELECT(cx_ljxt, token); ViewBag.TYPE = TYPE; cx_ljxt.TYPEID = 44; MES_SY_TYPEMXLIST[] PAPER = mesModels.SY_TYPEMX.SELECT(cx_ljxt, token); ViewBag.PAPER = PAPER; return(View()); }
public int Data_Insert_QingJia(string data) { token = appClass.CRM_Gettoken(); CRM_KQ_YGQJ model = JsonConvert.DeserializeObject <CRM_KQ_YGQJ>(data); int i = crmModels.KQ_YGQJ.Create(model, token); return(i); }
public int Data_Insert_BFDJ(string data) { token = appClass.CRM_Gettoken(); CRM_BF_BFDJ model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_BF_BFDJ>(data); model.JHBFKSSJ = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); if (model.ISACTIVE == 1) { model.JHBFJSSJ = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } else { model.JHBFJSSJ = ""; } int i = crmModels.BF_BF.Create_BFDJ(model, token); return(i); }
public string READ_TMINFO(string data) { token = appClass.CRM_Gettoken(); var url = section + "api/WMS/BC_TM/READ"; var restClient = new RestClient(url); var restRequest = new RestRequest(Method.POST); restRequest.AddHeader("Sonluk-Token", token); restRequest.RequestFormat = DataFormat.Json; restRequest.AddBody(data); var response = restClient.Execute(restRequest); var jsonData = (JObject)JsonConvert.DeserializeObject(response.Content); return(Newtonsoft.Json.JsonConvert.SerializeObject(jsonData)); }
public ActionResult SYS_Info() { token = appClass.CRM_Gettoken(); Session["location"] = 557; MSG_MSG_TYPE cxmodel = new MSG_MSG_TYPE(); MSG_MSG_TYPE[] MSGTYPE = msgModels.MSG_TYPE.ReadByParam(cxmodel, token); ViewBag.MSGTYPE = MSGTYPE; CRM_HG_DICT[] MODE = crmModels.HG_DICT.Read(116, 0, token); ViewBag.MODE = MODE; return(View()); }
public ActionResult BHGDJ() { Session["location"] = 212; token = appClass.CRM_Gettoken(); FIVES_STAFF_DEP DEPmodel = new FIVES_STAFF_DEP(); DEPmodel.STAFFID = appClass.CRM_GetStaffid(); FIVES_STAFF_DEP[] DEPdata = fivesmodels.STAFF_DEP.Read(DEPmodel, token); List <FIVES_STAFF_DEP> DEPlist = DEPdata.ToList(); DEPlist = DEPlist.DistinctBy(p => p.DEPTID).ToList(); DEPdata = DEPlist.ToArray(); ViewBag.DeptArr = DEPdata; return(View()); }
public ActionResult ElectricInvoice() { Session["location"] = 11000; ViewBag.STAFFNAME = Session["NAME"]; ViewBag.YEAR = DateTime.Now.Year; token = appClass.CRM_Gettoken(); int STAFFID = Convert.ToInt32(Session["STAFFID"].ToString()); HR_SY_GS_SELECT GCData = hrmodels.SY_GS.SELECT_BY_ROLE(STAFFID, token); ViewBag.GCData = GCData; return(View()); }
public string Data_Insert_Product(string data) { token = appClass.CRM_Gettoken(); CRM_PRODUCT_PRODUCT model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_PRODUCT_PRODUCT>(data); model.CJR = appClass.CRM_GetStaffid(); model.ISACTIVE = 1; int i = crmModels.PRODUCT_PRODUCT.Create(model, token); webmsg.KEY = i; if (i > 0) { webmsg.MSG = "新增成功"; } else { webmsg.MSG = "新增失败!"; } return(Newtonsoft.Json.JsonConvert.SerializeObject(webmsg)); }
public ActionResult ScanFAHUO_JHDPart(string VBELN) { token = appClass.CRM_Gettoken(); MODEL_ZBCFUN_JHD_READ data = crmModels.BarCode.JHD_READ(VBELN, token); ViewBag.data = data; CRM_BC_FXCHMX cx_fxch = new CRM_BC_FXCHMX(); cx_fxch.VBELN = VBELN; CRM_BC_FXCHMX[] FXCHdata = crmModels.BC_FXCH.ReadMXbyParam(cx_fxch, token); ViewBag.FXCHdata = FXCHdata; return(View()); }
public ActionResult Insert_Order() { token = appClass.CRM_Gettoken(); CRM_HG_STAFF STAFF = crmModels.HG_STAFF.ReadBySTAFFID(appClass.CRM_GetStaffid(), token); //STAFF为当前用户的数据 ViewBag.STAFF = STAFF; string SAPSN = STAFF.STAFFNO; CRM_KH_KH[] SDF = crmModels.KH_KH.ReadSDFbyPKH(SAPSN, token); ViewBag.SDF = SDF; CRM_KH_KH KH = crmModels.KH_KH.ReadBySAPSN(SAPSN, token); //kh为当前客户的数据 ViewBag.KH = KH; DateTime now = DateTime.Now; ViewBag.startdate = now.AddMonths(-1).ToString("yyyy-MM-dd"); ViewBag.enddate = now.ToString("yyyy-MM-dd"); return(View()); }
public int Data_Insert_Dep(string data) //新建部门 { token = appClass.CRM_Gettoken(); CRM_HG_DEPT model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_HG_DEPT>(data); int i = crmModels.HG_DEPT.Create(model, token); return(i); }
public string Data_Insert_PM(string data, string isTuiHuo) { token = appClass.CRM_Gettoken(); try { CRM_BC_PMLIST model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_BC_PMLIST>(data); model.CJR = appClass.CRM_GetStaffid(); CRM_BC_PMLISTList[] xianyouData = crmModels.BC_PMLIST.SelectByGD(model.AUFNR, token); if (xianyouData.Length != 0) //已经有该工单的数据 { if (xianyouData[0].CHARG != model.CHARG) { return("已存在该工单,且日期唛不一致"); } if (xianyouData[0].PM == "" && xianyouData[xianyouData.Length - 1].PM == "") //数据库里有该工单的信息,但箱码还未生成喷码 { int error = crmModels.BC_PMLIST.UpdatePM(token); //生成喷码 if (error != 0) { return("喷码生成失败,请重试"); } } else //该工单的箱码已经生成了喷码 { MODEL_ZBCFUN_TM_READ TMmodel = crmModels.BarCode.GET_ZBCFUN_TM_READ(model.AUFNR, "F", token); if (TMmodel.ET_TM.Length == 0) { return("该工单没有所属箱码"); } List <ZSL_BCT100> ET_TM = TMmodel.ET_TM.ToList(); //ET_TM = (from o in ET_TM orderby (o.DXM.Substring(2,o.DXM.Length-2)) select o).ToList(); ET_TM = ET_TM.OrderBy(u => u.TPM.Substring(2, u.TPM.Length - 2)).ThenBy(u => u.DXM.Substring(2, u.DXM.Length - 2)).ToList(); string PM = ""; if (isTuiHuo == "1") //如果是退货的话喷码统一为ZAA { PM = "ZAA"; } string TPM_temp = ""; int isexist = 0; //变成1表示当前行是这回刚增进去的,所以其对应的托码整个都要增进去 for (int x = 0; x < ET_TM.Count; x++) //按箱码进行循环 { CRM_BC_PMLIST cxmodel = new CRM_BC_PMLIST(); if (ET_TM[x].TPM != TPM_temp) //当托码变化时,去数据库看下这个托码是否已经存在 { isexist = 0; cxmodel.AUFNR = model.AUFNR; cxmodel.TPM = ET_TM[x].TPM; cxmodel.PMTYPE = 1; CRM_BC_PMLIST[] cxresult = crmModels.BC_PMLIST.SelectByModel(cxmodel, "", "", token); if (cxresult.Length != 0 && isexist == 0) //已经有这个托码了,就跳过 { continue; } else //这个托码还没生成喷码 { isexist = 1; model.DXM = ET_TM[x].DXM; model.TPM = ET_TM[x].TPM; model.PM = PM; model.PMTYPE = 1; //根据工单 int i = crmModels.BC_PMLIST.Create(model, token); if (i <= 0) { return("生成失败!"); } } } else { if (isexist == 1) { model.DXM = ET_TM[x].DXM; model.TPM = ET_TM[x].TPM; model.PM = PM; model.PMTYPE = 1; //根据工单 int i = crmModels.BC_PMLIST.Create(model, token); if (i <= 0) { return("生成失败!"); } } else { continue; } } TPM_temp = ET_TM[x].TPM; } } } else //数据库里没有该工单的数据 { MODEL_ZBCFUN_TM_READ TMmodel = crmModels.BarCode.GET_ZBCFUN_TM_READ(model.AUFNR, "F", token); if (TMmodel.ET_TM.Length == 0) { return("该工单没有所属箱码"); } List <ZSL_BCT100> ET_TM = TMmodel.ET_TM.ToList(); //ET_TM = (from o in ET_TM orderby (o.DXM.Substring(2,o.DXM.Length-2)) select o).ToList(); ET_TM = ET_TM.OrderBy(u => u.TPM.Substring(2, u.TPM.Length - 2)).ThenBy(u => u.DXM.Substring(2, u.DXM.Length - 2)).ToList(); string PM = ""; if (isTuiHuo == "1") //如果是退货的话喷码统一为ZAA { PM = "ZAA"; } for (int x = 0; x < ET_TM.Count; x++) { model.DXM = ET_TM[x].DXM; model.TPM = ET_TM[x].TPM; model.PM = PM; model.PMTYPE = 1; //根据工单 int i = crmModels.BC_PMLIST.Create(model, token); if (i <= 0) { return("生成失败!"); } } //if (isTuiHuo == "0") //不是退货的话需要生成喷码 //{ // int error = crmModels.BC_PMLIST.UpdatePM(token); //生成喷码 // if (error != 0) // { // return "喷码生成失败,请重试"; // } //} } } catch (Exception e) { return(e.Message); } return("生成成功!"); }
public ActionResult Basic() { token = appClass.CRM_Gettoken(); CRM_QYJS_MENU model = new CRM_QYJS_MENU(); model.PLOGID = 2; CRM_QYJS_MENU[] data = crmModels.QYJS_MENU.ReadTTbyParam(model, token); ViewBag.data = data; return(View()); }
public ActionResult Show_Notice(int NoticeTTid) { token = appClass.CRM_Gettoken(); CRM_MSG_NOTICETTList data = crmModels.MSG_NOTICE.ReadTTbyTTID(NoticeTTid, token); return(View()); }
public ActionResult Select() { token = appclass.CRM_Gettoken(); Session["location"] = 10; //return PartialView("Select"); CRM_HG_DEPT[] DEPTdata = crmModels.HG_DEPT.Read(token); ViewBag.DEPTdata = DEPTdata; CRM_HG_DICT[] JOB = crmModels.HG_DICT.Read(13, 0, token); CRM_HG_DICT[] POST = crmModels.HG_DICT.Read(14, 0, token); CRM_HG_DICT[] XUELI = crmModels.HG_DICT.Read(16, 0, token); CRM_HG_DICT[] STAFFTYPE = crmModels.HG_DICT.Read(33, 0, token); ViewBag.JOB = JOB; ViewBag.POST = POST; ViewBag.XUELI = XUELI; ViewBag.STAFFTYPE = STAFFTYPE; return(View()); }
public ActionResult CheckPoint() { Session["location"] = 206; token = appClass.CRM_Gettoken(); HR_SY_DEPT_SELECT r = hrmodels.SY_DEPT.SELECT(new HR_SY_DEPT(), token); ViewBag.DEPList = r; FIVES_SY_DICT model = new FIVES_SY_DICT(); FIVES_SY_TYPE TYPEmodel = new FIVES_SY_TYPE(); TYPEmodel.TYPENAME = "检查频率"; FIVES_SY_TYPE[] TYPEDATA = fivesmodels.SY_TYPE.Read(TYPEmodel, token); model.TYPEID = TYPEDATA[0].TYPEID; FIVES_SY_DICT[] RES = fivesmodels.SY_DICT.Read(model, token); ViewBag.RES = RES; FIVES_SY_DICT cxmodel = new FIVES_SY_DICT(); FIVES_SY_TYPE TYPEmodel2 = new FIVES_SY_TYPE(); TYPEmodel2.TYPENAME = "检查类型"; FIVES_SY_TYPE[] TYPEDATA2 = fivesmodels.SY_TYPE.Read(TYPEmodel2, token); model.TYPEID = TYPEDATA2[0].TYPEID; FIVES_SY_DICT[] JCRES = fivesmodels.SY_DICT.Read(model, token); List <FIVES_SY_DICT> ListJcres = JCRES.ToList(); for (int i = JCRES.Length - 1; i >= 0; i--) { if (JCRES[i].DICNAME == "抽检") { ListJcres[i].DICID = 0; } if (JCRES[i].DICNAME == "巡检") { ListJcres[i].DICID = 0; } } FIVES_SY_DICT[] JCRES_set = ListJcres.ToArray(); ViewBag.JCRES = JCRES_set; return(View()); }