public string Data_Select_CCTT_ByCCID(int CCID) { token = appClass.CRM_Gettoken(); CRM_KQ_CCTT data = crmModels.KQ_CC.Read_TTbyCCID(CCID, token); DateTime date = new DateTime(); date = Convert.ToDateTime(data.JHCCKSSJ); data.JHCCKSSJ = date.ToString("yyyy-MM-dd HH:mm:ss"); date = Convert.ToDateTime(data.JHCCJSSJ); data.JHCCJSSJ = date.ToString("yyyy-MM-dd HH:mm:ss"); date = Convert.ToDateTime(data.SJKSSJ); data.SJKSSJ = date.ToString("yyyy-MM-dd HH:mm:ss"); date = Convert.ToDateTime(data.SJCCJSSJ); data.SJCCJSSJ = date.ToString("yyyy-MM-dd HH:mm:ss"); date = Convert.ToDateTime(data.CCSQSJ); data.CCSQSJ = date.ToString("yyyy-MM-dd HH:mm:ss"); string s = Newtonsoft.Json.JsonConvert.SerializeObject(data); return(s); }
public int Data_Update_CCTT(string data) { token = appClass.CRM_Gettoken(); CRM_KQ_CCTT model = JsonConvert.DeserializeObject <CRM_KQ_CCTT>(data); int i = crmModels.KQ_CC.Update_TT(model, token); return(i); }
public string Data_Select_CCTT_ByModel(string cxdata, int status) { token = appClass.CRM_Gettoken(); CRM_KQ_CCTT model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_KQ_CCTT>(cxdata); model.STAFFID = Convert.ToInt32(Session["STAFFID"]); Sonluk.UI.Model.CRM.KQ_CCService.CRM_KQ_CCTTList[] data = crmModels.KQ_CC.Read_TTbyParam(model, status, token); string s = Newtonsoft.Json.JsonConvert.SerializeObject(data); return(s); }
public CRM_KQ_CCTTList[] Read_TTbyParam(CRM_KQ_CCTT model, int STATUS, string ptoken) { return(client.Read_TTbyParam(model, STATUS, ptoken)); }
public int Update_TT(CRM_KQ_CCTT model, string ptoken) { return(client.Update_TT(model, ptoken)); }
public string Data_Submit_ChuChaiHeXiao(string _list, int CCID, int staffid) { token = appClass.CRM_Gettoken(); CRM_OA_BASIC basic = new CRM_OA_BASIC(); basic.LoginName = crmModels.HG_STAFF.ReadBySTAFFID(staffid, token).STAFFNO; basic.TemplateCode = crmModels.SYS_CS.Read(6, token)[0].CS.ToString(); basic.Subject = "出差核销单(" + crmModels.HG_STAFF.ReadBySTAFFID(staffid, token).STAFFNAME; CRM_OA_CC list = JsonConvert.DeserializeObject <CRM_OA_CC>(_list); CRM_KQ_CCTT CCmodel = crmModels.KQ_CC.Read_TTbyCCID(CCID, token); if (CCmodel.ISACTIVE != 3 && CCmodel.ISACTIVE != 4) { MessageInfo msg = new MessageInfo(); msg.Key = "0"; msg.Value = "当前状态不可提交"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } if (CCmodel.SJJE.ToString() == "") { MessageInfo msg = new MessageInfo(); msg.Key = "0"; msg.Value = "实际金额不可为空"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } //校验明细的目标完成情况是不是都填了 CRM_KQ_CCMX[] MXmodel = crmModels.KQ_CC.Read_MXbyCCID(CCID, token); for (int i = 0; i < MXmodel.Length; i++) { if (MXmodel[i].MBWCQK == "") { MessageInfo msg = new MessageInfo(); msg.Key = "0"; msg.Value = "请检查目标完成情况是否填写完整"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } } list.BEIZ = CCmodel.BEIZ; if (list.QTCXFSJE == "0" || list.QTCXFSJE == "0.00") { list.QTCXFSJE = ""; } CRM_KQ_CCMXList[] mxmodel = crmModels.KQ_CC.Read_MXQDbyCCID(CCID, token); list.CRM_OA_CC_SUBList = new CRM_OA_CC_SUB[mxmodel.Length]; for (int i = 0; i < mxmodel.Length; i++) { list.CRM_OA_CC_SUBList[i] = new CRM_OA_CC_SUB(); list.CRM_OA_CC_SUBList[i].DATE = mxmodel[i].DATE; string sjlx = ""; //上午或下午 if (mxmodel[i].CCSJLX == 1) { sjlx = "上午"; } else if (mxmodel[i].CCSJLX == 2) { sjlx = "下午"; } list.CRM_OA_CC_SUBList[i].CCSJLXDES = sjlx; list.CRM_OA_CC_SUBList[i].DD = mxmodel[i].DD; list.CRM_OA_CC_SUBList[i].GZMB = mxmodel[i].GZMB; list.CRM_OA_CC_SUBList[i].MBWCQK = mxmodel[i].MBWCQK; list.CRM_OA_CC_SUBList[i].QDWZ = mxmodel[i].QDSJ + " " + mxmodel[i].QDWZ; } CRM_HG_WJJL[] imgdata = crmModels.HG_WJJL.Read(9, CCID, token); string[] img = new string[imgdata.Length]; for (int i = 0; i < imgdata.Length; i++) { img[i] = imgdata[i].ML; } list.IMG = img; MessageInfo info = crmModels.CRM_OA.Launch(basic, list, token); //提交 if (info.Key != "0" && info.Key != "-1") { CRM_KQ_CCTT data = crmModels.KQ_CC.Read_TTbyCCID(CCID, token); data.ISACTIVE = 5; crmModels.KQ_CC.Update_TT(data, token); CRM_OA_TRANSMIT model = new CRM_OA_TRANSMIT(); model.OAID = info.Key; model.OACSBH = CCID; model.OACSLB = 105; model.OAZT = 3; model.CJSJ = DateTime.Now.ToString("yyyy-MM-dd"); crmModels.OA_TRANSMIT.Create(model, token); } return(Newtonsoft.Json.JsonConvert.SerializeObject(info)); }
public string Data_Submit_ChuChai(string _basic, string _list, int CCID, int staffid, int type) { token = appClass.CRM_Gettoken(); //先校验这个ccid对应的天数是否等于明细的条数 CRM_KQ_CCTT CCdata = crmModels.KQ_CC.Read_TTbyCCID(CCID, token); CRM_KQ_CCMX[] mxmodel = crmModels.KQ_CC.Read_MXbyCCID(CCID, token); if (CCdata.SJCCTS * 2 > mxmodel.Length) { return("0"); } CRM_OA_BASIC basic = JsonConvert.DeserializeObject <CRM_OA_BASIC>(_basic); basic.LoginName = crmModels.HG_STAFF.ReadBySTAFFID(staffid, token).STAFFNO; basic.TemplateCode = crmModels.SYS_CS.Read(5, token)[0].CS.ToString(); CRM_OA_CC list = JsonConvert.DeserializeObject <CRM_OA_CC>(_list); //list.DEP = crmModels.HG_DEPT.ReadByDEPID(DEP, token).DEPNAME; list.CXFS = crmModels.HG_DICT.ReadByDICID(Convert.ToInt32(list.CXFS), token).DICNAME; switch (type) { case 1: list.TITLE = "出差申请单"; break; case 2: list.TITLE = "出差变更申请单"; break; case 3: list.TITLE = "出差撤销申请单"; break; default: list.TITLE = ""; break; } list.BEIZ = CCdata.BEIZ; if (list.QTCXFSJE == "0" || list.QTCXFSJE == "0.00") { list.QTCXFSJE = ""; } list.CRM_OA_CC_SUBList = new CRM_OA_CC_SUB[mxmodel.Length]; for (int i = 0; i < mxmodel.Length; i++) { list.CRM_OA_CC_SUBList[i] = new CRM_OA_CC_SUB(); list.CRM_OA_CC_SUBList[i].DATE = mxmodel[i].DATE; string sjlx = ""; //上午或下午 if (mxmodel[i].CCSJLX == 1) { sjlx = "上午"; } else if (mxmodel[i].CCSJLX == 2) { sjlx = "下午"; } list.CRM_OA_CC_SUBList[i].CCSJLXDES = sjlx; list.CRM_OA_CC_SUBList[i].DD = mxmodel[i].DD; list.CRM_OA_CC_SUBList[i].GZMB = mxmodel[i].GZMB; } MessageInfo info = crmModels.CRM_OA.Launch(basic, list, token); //提交 if (info.Key != "0" && info.Key != "-1") { CRM_KQ_CCTT data = crmModels.KQ_CC.Read_TTbyCCID(CCID, token); data.ISACTIVE = 2; crmModels.KQ_CC.Update_TT(data, token); CRM_OA_TRANSMIT model = new CRM_OA_TRANSMIT(); model.OAID = info.Key; model.OACSBH = CCID; model.OACSLB = 93; model.OAZT = 1; model.CJSJ = DateTime.Now.ToString("yyyy-MM-dd"); crmModels.OA_TRANSMIT.Create(model, token); } return(Newtonsoft.Json.JsonConvert.SerializeObject(info)); }
public string Data_Modify_CCTT(int CCID, string beiz) { token = appClass.CRM_Gettoken(); CRM_KQ_CCTT model = crmModels.KQ_CC.Read_TTbyCCID(CCID, token); model.BEIZ = beiz; int int1 = crmModels.KQ_CC.Update_TT(model, token); if (int1 <= 0) { MessageInfo msg = new MessageInfo(); msg.Key = "0"; msg.Value = "保存失败!"; return(Newtonsoft.Json.JsonConvert.SerializeObject(msg)); } ////先校验这个ccid对应的天数是否等于明细的条数 //CRM_KQ_CCMX[] mxmodel = crmModels.KQ_CC.Read_MXbyCCID(model.CCID, token); //if (model.SJCCTS * 2 > mxmodel.Length) //{ // MessageInfo msg = new MessageInfo(); // msg.Key = "0"; // msg.Value = "请确认明细数量与出差天数是否对应!"; // return Newtonsoft.Json.JsonConvert.SerializeObject(msg); //} ////然后先保存 //int id = crmModels.KQ_CC.Update_TT(model, token); //if (id <= 0) //{ // MessageInfo msg = new MessageInfo(); // msg.Key = "0"; // msg.Value = "保存失败,未发起OA流程"; // return Newtonsoft.Json.JsonConvert.SerializeObject(msg); //} //开始做OA CRM_HG_STAFF staffmodel = crmModels.HG_STAFF.ReadBySTAFFID(Convert.ToInt32(Session["STAFFID"]), token); CRM_OA_BASIC basic = new CRM_OA_BASIC(); basic.Subject = "出差撤销单(" + staffmodel.STAFFNAME + " "; basic.LoginName = crmModels.HG_STAFF.ReadBySTAFFID(staffmodel.STAFFID, token).STAFFNO; basic.TemplateCode = crmModels.SYS_CS.Read(5, token)[0].CS.ToString(); CRM_OA_CC list = new CRM_OA_CC(); list.CCSQSJ = model.CCSQSJ; list.STAFFNAME = model.CCRNAME; list.CCLXDES = crmModels.HG_DICT.ReadByDICID(Convert.ToInt32(model.CCLX), token).DICNAME; list.CCDD = model.CCDD; list.BQYCCDES = model.BQYCC == true ? "是" : "否"; list.ZCYWCCDES = model.ZCYWCC == true ? "是" : "否"; list.JHCCKSSJ = model.JHCCKSSJ; list.JHCCJSSJ = model.JHCCJSSJ; list.CXFS = crmModels.HG_DICT.ReadByDICID(Convert.ToInt32(model.CXFS), token).DICNAME; list.YJJE = model.YJJE.ToString(); list.QTCXFSDES = crmModels.HG_DICT.ReadByDICID(Convert.ToInt32(model.QTCXFS), token).DICNAME; list.QTCXFSJE = model.QTCXFSJE.ToString(); list.BEIZ = model.BEIZ; if (list.QTCXFSJE == "0" || list.QTCXFSJE == "0.00") { list.QTCXFSJE = ""; } list.TITLE = "出差撤销单"; CRM_KQ_CCMX[] mxmodel = crmModels.KQ_CC.Read_MXbyCCID(model.CCID, token); list.CRM_OA_CC_SUBList = new CRM_OA_CC_SUB[mxmodel.Length]; for (int i = 0; i < mxmodel.Length; i++) { list.CRM_OA_CC_SUBList[i] = new CRM_OA_CC_SUB(); list.CRM_OA_CC_SUBList[i].DATE = mxmodel[i].DATE; string sjlx = ""; //上午或下午 if (mxmodel[i].CCSJLX == 1) { sjlx = "上午"; } else if (mxmodel[i].CCSJLX == 2) { sjlx = "下午"; } list.CRM_OA_CC_SUBList[i].CCSJLXDES = sjlx; list.CRM_OA_CC_SUBList[i].DD = mxmodel[i].DD; list.CRM_OA_CC_SUBList[i].GZMB = mxmodel[i].GZMB; } MessageInfo info = crmModels.CRM_OA.Launch(basic, list, token); //提交 if (info.Key != "0" && info.Key != "-1") { model.ISACTIVE = 2; crmModels.KQ_CC.Update_TT(model, token); CRM_OA_TRANSMIT TRANSMITmodel = new CRM_OA_TRANSMIT(); TRANSMITmodel.OAID = info.Key; TRANSMITmodel.OACSBH = model.CCID; TRANSMITmodel.OACSLB = 1083; TRANSMITmodel.OAZT = 1; TRANSMITmodel.CJSJ = DateTime.Now.ToString("yyyy-MM-dd"); crmModels.OA_TRANSMIT.Create(TRANSMITmodel, token); } return(Newtonsoft.Json.JsonConvert.SerializeObject(info)); }