public JObject xInitData() { JObject re_jo = new JObject(); string str = System.IO.File.ReadAllText(Server.MapPath("xInitData.json")); re_jo = JsonConvert.DeserializeObject <JObject>(str); string id = ""; string bsrq = ""; string rqQ = ""; string rqZ = ""; GTXResult resultq = GTXMethod.GetGuiZhouYSBQC(); if (resultq.IsSuccess) { List <GDTXGuiZhouUserYSBQC> ysbqclist = JsonConvert.DeserializeObject <List <GDTXGuiZhouUserYSBQC> >(resultq.Data.ToString()); if (ysbqclist.Count > 0) { foreach (GDTXGuiZhouUserYSBQC item in ysbqclist) { if (item.BDDM == this.BDDM) { id = item.Id.ToString(); bsrq = item.HappenDate; rqQ = item.SKSSQQ; rqZ = item.SKSSQZ; } } } } JObject re_jo_body = new JObject(); re_jo_body = JsonConvert.DeserializeObject <JObject>(re_jo["body"].ToString()); GTXResult gr = GTXMethod.GetUserReportData(id, this.BDDM); if (gr.IsSuccess) { JArray jarr = new JArray(); jarr = JsonConvert.DeserializeObject <JArray>(gr.Data.ToString()); if (jarr.Count > 0) { byte[] bytes = Convert.FromBase64String(jarr[0]["dataValue"].ToString().Replace(" ", "+")); string dataValue = Encoding.Default.GetString(bytes); re_jo_body = JsonConvert.DeserializeObject <JObject>(dataValue); } } re_jo_body["qcs"]["bsrq"] = new JValue(bsrq); re_jo_body["ZlbssldjNsrxxVO"]["ssqq"] = new JValue(rqQ); re_jo_body["ZlbssldjNsrxxVO"]["ssqz"] = new JValue(rqZ); re_jo["body"] = re_jo_body; JObject nsrxx_jo = GTXMethod.getNsrxx((JObject)re_jo["body"]["qcs"]["djNsrxx"]); re_jo["body"]["qcs"]["djNsrxx"] = nsrxx_jo; return(re_jo); }
public JObject getQYSDS_JM_YJ_A_Public(ref JObject re_json, string SBBZL_DM) { string id = ""; GDTXGuangXiUserYSBQC ysbqc = GTXMethod.GetYSBQCByBDDM(BDDM); id = ysbqc.Id.ToString(); re_json["data"]["HEAD"]["SSSQ_Q"] = new JValue(ysbqc.SKSSQQ); re_json["data"]["HEAD"]["SSSQ_Z"] = new JValue(ysbqc.SKSSQZ); JObject data_json = new JObject(); GTXResult gr = GTXMethod.GetUserReportData(id, SBBZL_DM); if (gr.IsSuccess) { JArray jarr = new JArray(); jarr = JsonConvert.DeserializeObject <JArray>(gr.Data.ToString()); if (jarr.Count > 0) { byte[] bytes = Convert.FromBase64String(jarr[0]["dataValue"].ToString().Replace(" ", "+")); string dataValue = System.Text.Encoding.Default.GetString(bytes); data_json = JsonConvert.DeserializeObject <JObject>(dataValue); } } return(data_json); }
public JObject xInitData() { JObject re_json = new JObject(); string str = System.IO.File.ReadAllText(Server.MapPath("xInitData.init.json")); re_json = JsonConvert.DeserializeObject <JObject>(str); JObject re_json_body = JsonConvert.DeserializeObject <JObject>(re_json["body"].Value <string>()); GDTXGuiZhouUserYSBQC item = GTXMethod.GetYSBQCByBDDM(this.BDDM); GTXResult gr = GTXMethod.GetUserReportData(item.Id.ToString(), this.BDDM); if (gr.IsSuccess) { JArray jarr = new JArray(); jarr = JsonConvert.DeserializeObject <JArray>(gr.Data.ToString()); if (jarr.Count > 0) { byte[] bytes = Convert.FromBase64String(jarr[0]["dataValue"].ToString().Replace(" ", "+")); string dataValue = Encoding.Default.GetString(bytes); re_json_body = JsonConvert.DeserializeObject <JObject>(dataValue); } } JObject re_json_body_fq = (JObject)re_json_body["fq"]; re_json_body_fq["nsrjbxx"]["tbrq"] = item.HappenDate; re_json_body_fq["sssq"]["sqQ"] = item.SKSSQQ; re_json_body_fq["sssq"]["sqZ"] = item.SKSSQZ; //企业所得税期初数设置 string Name = System.Web.HttpContext.Current.Session["Name"].ToString(); JToken industry = JToken.Parse(System.IO.File.ReadAllText(Server.MapPath("~/industry.json"))); industry = industry.Where(a => a["name"].ToString() == Name).ToList()[0]; re_json_body["ht"]["qysdsczzsyjdSbbdxxVO"]["A200000Ywbd"]["sbbxxForm"] = JObject.Parse(System.IO.File.ReadAllText(Server.MapPath("~/QYSDS_A_18YJD." + industry["value"] + ".json"))); GTXResult gr1 = GTXMethod.GetCompany(); if (gr1.IsSuccess) { JObject jo = new JObject(); jo = JsonConvert.DeserializeObject <JObject>(gr1.Data.ToString()); if (jo.HasValues) { JObject data_jo = jo; re_json_body_fq["nsrjbxx"]["nsrsbh"] = data_jo["NSRSBH"].ToString(); re_json_body_fq["nsrjbxx"]["nsrmc"] = data_jo["NSRMC"].ToString(); } } JValue jv = new JValue(JsonConvert.SerializeObject(re_json_body, Formatting.None)); re_json["body"] = jv; re_json["flagExecuteInitial"] = new JValue(false); return(re_json); }
public JArray xSheets() { JArray re_j = new JArray(); string str = System.IO.File.ReadAllText(Server.MapPath("xSheets.json")); re_j = JsonConvert.DeserializeObject <JArray>(str); string id = ""; GTXResult resultq = GTXMethod.GetGuiZhouYSBQC(); if (resultq.IsSuccess) { List <GDTXGuiZhouUserYSBQC> ysbqclist = JsonConvert.DeserializeObject <List <GDTXGuiZhouUserYSBQC> >(resultq.Data.ToString()); if (ysbqclist.Count > 0) { foreach (GDTXGuiZhouUserYSBQC item in ysbqclist) { if (item.BDDM == "YBNSRZZS") { id = item.Id.ToString(); } } } } GTXResult gr = GTXMethod.GetUserReportData(id, "YBNSRZZSXBSZ"); if (gr.IsSuccess) { JArray jarr = new JArray(); jarr = JsonConvert.DeserializeObject <JArray>(gr.Data.ToString()); if (jarr.Count > 0) { byte[] bytes = Convert.FromBase64String(jarr[0]["dataValue"].ToString().Replace(" ", "+")); string dataValue = Encoding.Default.GetString(bytes); JObject data_jo = JsonConvert.DeserializeObject <JObject>(dataValue); JObject data_jo_jcxxsz = (JObject)data_jo["jcxxsz"]; for (int i = re_j.Count - 1; i >= 0; i--) { string s = data_jo_jcxxsz["" + re_j[i]["dzbdbm"] + ""].ToString(); if (s == "N") { re_j.RemoveAt(i); } } } } return(re_j); }
public JObject getSB_ZZS_XGMNSR_Public(ref JObject re_json, string SBBZL_DM) { string id = ""; string tbrq = ""; string rqQ = ""; string rqZ = ""; GTXResult resultq = GTXMethod.GetGuangXiYSBQC(); if (resultq.IsSuccess) { List <GDTXGuangXiUserYSBQC> ysbqclist = JsonConvert.DeserializeObject <List <GDTXGuangXiUserYSBQC> >(resultq.Data.ToString()); if (ysbqclist.Count > 0) { foreach (GDTXGuangXiUserYSBQC item in ysbqclist) { if (item.BDDM == "XGMZZS") { id = item.Id.ToString(); tbrq = item.HappenDate; rqQ = item.SKSSQQ; rqZ = item.SKSSQZ; } } } } re_json["data"]["HEAD"]["TBRQ"] = new JValue(tbrq); re_json["data"]["HEAD"]["SSSQ_Q"] = new JValue(rqQ); re_json["data"]["HEAD"]["SSSQ_Z"] = new JValue(rqZ); JObject data_json = new JObject(); GTXResult gr = GTXMethod.GetUserReportData(id, SBBZL_DM); if (gr.IsSuccess) { JArray jarr = new JArray(); jarr = JsonConvert.DeserializeObject <JArray>(gr.Data.ToString()); if (jarr.Count > 0) { byte[] bytes = Convert.FromBase64String(jarr[0]["dataValue"].ToString().Replace(" ", "+")); string dataValue = System.Text.Encoding.Default.GetString(bytes); data_json = JsonConvert.DeserializeObject <JObject>(dataValue); } } return(data_json); }
public void getZZS_XSSR(ref JObject re_json) { string id = ""; GTXResult resultq = GTXMethod.GetGuangXiYSBQC(); if (resultq.IsSuccess) { List <GDTXGuangXiUserYSBQC> ysbqclist = JsonConvert.DeserializeObject <List <GDTXGuangXiUserYSBQC> >(resultq.Data.ToString()); if (ysbqclist.Count > 0) { foreach (GDTXGuangXiUserYSBQC item in ysbqclist) { if (item.BDDM == "YBNSRZZS" || item.BDDM == "XGMZZS") { id = item.Id.ToString(); } } } } GTXResult gr = GTXMethod.GetUserReportData(id, "101011034"); if (gr.IsSuccess) { JArray jarr = new JArray(); jarr = JsonConvert.DeserializeObject <JArray>(gr.Data.ToString()); if (jarr.Count > 0) { byte[] bytes = Convert.FromBase64String(jarr[0]["dataValue"].ToString().Replace(" ", "+")); string dataValue = Encoding.Default.GetString(bytes); JObject data_json = JsonConvert.DeserializeObject <JObject>(dataValue); if (data_json.HasValues) { JArray data_body = (JArray)data_json["BODY"]; JArray re_DSLIST = (JArray)re_json["data"]["JCSJ"]["DSLIST"]; double XSSR = double.Parse(data_body[0]["COL09"].ToString()) + double.Parse(data_body[1]["COL09"].ToString()) + double.Parse(data_body[2]["COL09"].ToString()) + double.Parse(data_body[3]["COL09"].ToString()) + double.Parse(data_body[4]["COL09"].ToString()) + double.Parse(data_body[5]["COL09"].ToString()); re_DSLIST[0]["XSSR"] = new JValue(XSSR); re_DSLIST[1]["XSSR"] = new JValue(XSSR); re_DSLIST[2]["XSSR"] = new JValue(XSSR); } } } }
public string mainSettingForYBNSRZZS(string str, string ywbm) { JObject re_jo = new JObject(); JValue re_jv = new JValue(""); re_jv = JsonConvert.DeserializeObject <JValue>(str); re_jo = JsonConvert.DeserializeObject <JObject>(re_jv.ToString()); JObject re_jo_body = JsonConvert.DeserializeObject <JObject>(re_jo["body"].ToString()); GDTXGuiZhouUserYSBQC ysbqc = GTXMethod.GetYSBQCByBDDM("YBNSRZZS"); if (ywbm == "YBNSRZZSQCS") { re_jo_body["sssq"]["rqQ"] = ysbqc.SKSSQQ; re_jo_body["sssq"]["rqZ"] = ysbqc.SKSSQZ; re_jo["body"] = new JValue(re_jo_body.ToString()); str = "" + JsonConvert.SerializeObject(new JValue(JsonConvert.SerializeObject(re_jo))) + ""; } GTXResult gr = GTXMethod.GetUserReportData(ysbqc.Id.ToString(), ywbm); if (gr.IsSuccess) { JArray jarr = new JArray(); jarr = JsonConvert.DeserializeObject <JArray>(gr.Data.ToString()); if (jarr.Count > 0) { byte[] bytes = Convert.FromBase64String(jarr[0]["dataValue"].ToString().Replace(" ", "+")); string dataValue = Encoding.Default.GetString(bytes); JObject data_jo = JsonConvert.DeserializeObject <JObject>(dataValue); re_jo["body"] = new JValue(JsonConvert.SerializeObject(data_jo)); str = "" + JsonConvert.SerializeObject(new JValue(JsonConvert.SerializeObject(re_jo))) + ""; } } return(str); }
public void ProcessRequest(HttpContext context) { var result = ""; var orgstr = ""; context.Response.ContentType = "application/json"; HttpRequest request = context.Request; StreamReader reader = new StreamReader(request.InputStream); string json = reader.ReadToEnd(); JObject jo = JObject.Parse(json); var ysbqcid = jo["sbxh"].ToString(); GTXResult resultData = GTXMethod.GetUserReportData(ysbqcid, ""); if (resultData.IsSuccess) { var currentReportData = JsonConvert.DeserializeObject <List <GDTXHeBeiUserYSBQCReportData> >(resultData.Data.ToString()); var resultDataCount = currentReportData.Count; if (resultDataCount != 0) { result = File.ReadAllText(context.Server.MapPath("getsbbw.json")); List <GDTXHeBeiUserYSBQCReportData> dataList = JsonConvert.DeserializeObject <List <GDTXHeBeiUserYSBQCReportData> >(resultData.Data.ToString()); foreach (GDTXHeBeiUserYSBQCReportData item in dataList) { var orgStr = item.DataValue.Replace(" ", "+"); byte[] outputb = Convert.FromBase64String(orgStr); orgstr = Encoding.Default.GetString(outputb); JObject jon = JObject.Parse(orgstr); var sbformdata = jon["sbformdata"].ToString(); //orgStr = JsonConvert.SerializeObject(jo); //orgStrResult = orgStr.Replace("\"", "\\\"").Replace("\r\n", "").Replace("\\", ""); result = result.Replace("@@value", sbformdata); } } } context.Response.ContentType = "text/plain"; context.Response.Write(result); }
public JObject xInitData() { JObject re_jo = new JObject(); string str = System.IO.File.ReadAllText(Server.MapPath("xInitData.json")); re_jo = JsonConvert.DeserializeObject <JObject>(str); JObject re_jo_body = new JObject(); re_jo_body = JsonConvert.DeserializeObject <JObject>(re_jo["body"].ToString()); string id = ""; string tbrq = ""; string rqQ = ""; string rqZ = ""; GTXResult resultq = GTXMethod.GetGuiZhouYSBQC(); if (resultq.IsSuccess) { List <GDTXGuiZhouUserYSBQC> ysbqclist = JsonConvert.DeserializeObject <List <GDTXGuiZhouUserYSBQC> >(resultq.Data.ToString()); if (ysbqclist.Count > 0) { foreach (GDTXGuiZhouUserYSBQC item in ysbqclist) { if (item.BDDM == this.BDDM) { id = item.Id.ToString(); tbrq = item.HappenDate; rqQ = item.SKSSQQ; rqZ = item.SKSSQZ; } } } } re_jo_body["qcs"]["initData"]["nsrjbxx"]["tbrq"] = new JValue(tbrq); re_jo_body["qcs"]["initData"]["fjssbInitData"]["sssq"]["rqQ"] = new JValue(rqQ); re_jo_body["qcs"]["initData"]["fjssbInitData"]["sssq"]["rqZ"] = new JValue(rqZ); JObject nsrxx_jo = GTXMethod.getNsrxx((JObject)re_jo_body["qcs"]["initData"]["nsrjbxx"]); re_jo_body["qcs"]["initData"]["nsrjbxx"] = nsrxx_jo; GTXResult gr = GTXMethod.GetUserReportData(id, this.BDDM); if (gr.IsSuccess) { JArray jarr = new JArray(); jarr = JsonConvert.DeserializeObject <JArray>(gr.Data.ToString()); if (jarr.Count > 0) { byte[] bytes = Convert.FromBase64String(jarr[0]["dataValue"].ToString().Replace(" ", "+")); string dataValue = Encoding.Default.GetString(bytes); JObject data_jo = JsonConvert.DeserializeObject <JObject>(dataValue); JArray data_ja = (JArray)data_jo["fjsSbbdxxVO"]["fjssbb"]["sbxxGrid"]["sbxxGridlbVO"]; JArray mxxx = (JArray)re_jo_body["qcs"]["formContent"]["fjssbb"]["body"]["sbxxGrid"]["sbxxGridlbVO"]; for (int i = 0; i < data_ja.Count; i++) { mxxx[i]["zsxmMc"] = data_ja[i]["zsxmMc"]; mxxx[i]["zsxmDm"] = data_ja[i]["zsxmDm"]; mxxx[i]["zspmMc"] = data_ja[i]["zspmMc"]; mxxx[i]["zspmDm"] = data_ja[i]["zspmDm"]; mxxx[i]["ybzzs"] = data_ja[i]["ybzzs"]; mxxx[i]["zzsmdse"] = data_ja[i]["zzsmdse"]; mxxx[i]["xfs"] = data_ja[i]["xfs"]; mxxx[i]["yys"] = data_ja[i]["yys"]; mxxx[i]["hj"] = data_ja[i]["hj"]; mxxx[i]["sl1"] = data_ja[i]["sl1"]; mxxx[i]["bqybtse"] = data_ja[i]["bqybtse"]; } re_jo_body["qcs"]["formContent"]["fjssbb"]["body"]["sbxxGrid"]["sbxxGridlbVO"] = mxxx; } } re_jo["body"] = re_jo_body; return(re_jo); }
public string getsbxx() { string str = System.IO.File.ReadAllText(Server.MapPath("getsbxx.json")); JValue sbxx_jv = JsonConvert.DeserializeObject <JValue>(str); JObject sbxx_jo = JsonConvert.DeserializeObject <JObject>(sbxx_jv.ToString()); JArray sbxxList = (JArray)sbxx_jo["sbxxList"]; JObject sbxxList_model = (JObject)sbxxList[0]; sbxxList.RemoveAll(); GTXResult resultq = GTXMethod.GetGuiZhouYSBQC(); if (resultq.IsSuccess) { List <GDTXGuiZhouUserYSBQC> ysbqclist = JsonConvert.DeserializeObject <List <GDTXGuiZhouUserYSBQC> >(resultq.Data.ToString()); if (ysbqclist.Count > 0) { foreach (GDTXGuiZhouUserYSBQC item in ysbqclist) { if (item.SBZT == "未申报" || item.BDDM == "cwbb_qy_kjzz_ybqy") { continue; } else if (item.BDDM == "YHSSB") { GTXResult gr = GTXMethod.GetUserReportData(item.Id.ToString(), item.BDDM); if (gr.IsSuccess) { JArray jarr = new JArray(); jarr = JsonConvert.DeserializeObject <JArray>(gr.Data.ToString()); if (jarr.Count > 0) { byte[] bytes = Convert.FromBase64String(jarr[0]["dataValue"].ToString().Replace(" ", "+")); string dataValue = Encoding.Default.GetString(bytes); JObject data_jo = JsonConvert.DeserializeObject <JObject>(dataValue); JArray data_ja = (JArray)data_jo["yyssbbdxxVO"]["yhssb"]["yhssbGrid"]["yhssbGridlb"]; for (int i = 0; i < data_ja.Count; i++) { JObject sbxxList_item = new JObject(sbxxList_model); sbxxList_item["yzpzzlmc"] = item.TaskName; sbxxList_item["yzpzzlDm"] = item.BDDM; sbxxList_item["zsxmmc"] = item.ZSXM; sbxxList_item["sbrq"] = item.HappenDate; sbxxList_item["skssqq"] = item.SKSSQQ; sbxxList_item["skssqz"] = item.SKSSQZ; sbxxList_item["ybtse"] = data_ja[i]["bqybtse"]; sbxxList.Add(sbxxList_item); } } } } else { JObject sbxxList_item = new JObject(sbxxList_model); sbxxList_item["yzpzzlmc"] = item.TaskName; sbxxList_item["yzpzzlDm"] = item.BDDM; sbxxList_item["zsxmmc"] = item.ZSXM; sbxxList_item["sbrq"] = item.HappenDate; sbxxList_item["skssqq"] = item.SKSSQQ; sbxxList_item["skssqz"] = item.SKSSQZ; sbxxList_item["ybtse"] = item.SBSE; sbxxList.Add(sbxxList_item); } } } } sbxx_jo["sbxxList"] = sbxxList; JValue re_jv = new JValue(JsonConvert.SerializeObject(sbxx_jo)); string re_str = JsonConvert.SerializeObject(re_jv); return(re_str); }
public JObject getSB_FJS_ZB_Public(ref JObject re_json, string SBBZL_DM) { string id = ""; string tbrq = ""; string rqQ = ""; string rqZ = ""; GTXResult resultq = GTXMethod.GetGuangXiYSBQC(); if (resultq.IsSuccess) { List <GDTXGuangXiUserYSBQC> ysbqclist = JsonConvert.DeserializeObject <List <GDTXGuangXiUserYSBQC> >(resultq.Data.ToString()); if (ysbqclist.Count > 0) { foreach (GDTXGuangXiUserYSBQC item in ysbqclist) { if (item.BDDM == "FJSSB") { id = item.Id.ToString(); tbrq = item.HappenDate; rqQ = item.SKSSQQ; rqZ = item.SKSSQZ; } } } } re_json["data"]["HEAD"]["TBRQ"] = new JValue(tbrq); re_json["data"]["HEAD"]["SSSQ_Q"] = new JValue(rqQ); re_json["data"]["HEAD"]["SSSQ_Z"] = new JValue(rqZ); JObject in_jo = (JObject)re_json["data"]["HEAD"]; GTXResult gr1 = GTXMethod.GetCompany(); if (gr1.IsSuccess) { JObject jo = new JObject(); jo = JsonConvert.DeserializeObject <JObject>(gr1.Data.ToString()); if (jo.HasValues) { JObject data_jo = jo; in_jo["NSRSBH"] = data_jo["NSRSBH"]; in_jo["LXFS"] = data_jo["LXDH"]; } } JObject data_json = new JObject(); GTXResult gr = GTXMethod.GetUserReportData(id, ""); if (gr.IsSuccess) { JArray jarr = new JArray(); jarr = JsonConvert.DeserializeObject <JArray>(gr.Data.ToString()); IEnumerable <JToken> ejt = jarr.Where(a => a["dataKey"].ToString() == SBBZL_DM); if (ejt.Count() == 1) { JObject jobj = (JObject)ejt.ElementAt(0); byte[] bytes = Convert.FromBase64String(jobj["dataValue"].ToString().Replace(" ", "+")); string dataValue = Encoding.Default.GetString(bytes); data_json = JsonConvert.DeserializeObject <JObject>(dataValue); } } return(data_json); }
public JObject xInitData() { JObject re_jo = new JObject(); string str = System.IO.File.ReadAllText(Server.MapPath("xInitData.json")); re_jo = JsonConvert.DeserializeObject <JObject>(str); JObject re_jo_body = new JObject(); re_jo_body = JsonConvert.DeserializeObject <JObject>(re_jo["body"].ToString()); string id = ""; string sbrq = ""; string rqQ = ""; string rqZ = ""; GTXResult resultq = GTXMethod.GetGuiZhouYSBQC(); if (resultq.IsSuccess) { List <GDTXGuiZhouUserYSBQC> ysbqclist = JsonConvert.DeserializeObject <List <GDTXGuiZhouUserYSBQC> >(resultq.Data.ToString()); if (ysbqclist.Count > 0) { foreach (GDTXGuiZhouUserYSBQC item in ysbqclist) { if (item.BDDM == "YBNSRZZS") { id = item.Id.ToString(); sbrq = item.HappenDate; rqQ = item.SKSSQQ; rqZ = item.SKSSQZ; } } } } //JObject zzsybnsrsbInitData_jo = (JObject)re_jo_body["qcs"]["initData"]["zzsybnsrsbInitData"]; string Name = System.Web.HttpContext.Current.Session["Name"].ToString(); JToken industry = JToken.Parse(System.IO.File.ReadAllText(Server.MapPath("~/industry.json"))); industry = industry.Where(a => a["name"].ToString() == Name).ToList()[0]; JObject zzsybnsrsbInitData_jo = JObject.Parse(System.IO.File.ReadAllText(Server.MapPath("zzsybnsrsbInitData." + industry["value"] + ".json"))); GTXResult gr1 = GTXMethod.GetUserReportData(id, "YBNSRZZSQCS"); if (gr1.IsSuccess) { JArray jarr = new JArray(); jarr = JsonConvert.DeserializeObject <JArray>(gr1.Data.ToString()); if (jarr.Count > 0) { byte[] bytes = Convert.FromBase64String(jarr[0]["dataValue"].ToString().Replace(" ", "+")); string dataValue = Encoding.Default.GetString(bytes); zzsybnsrsbInitData_jo.Merge(JsonConvert.DeserializeObject <JObject>(dataValue), new JsonMergeSettings { MergeArrayHandling = MergeArrayHandling.Union }); } } zzsybnsrsbInitData_jo["sbrq"] = sbrq; zzsybnsrsbInitData_jo["sssq"]["rqQ"] = rqQ; zzsybnsrsbInitData_jo["sssq"]["rqZ"] = rqZ; re_jo_body["qcs"]["initData"]["zzsybnsrsbInitData"] = zzsybnsrsbInitData_jo; GTXResult gr2 = GTXMethod.GetUserReportData(id, "YBNSRZZS"); if (gr2.IsSuccess) { JArray jarr = new JArray(); jarr = JsonConvert.DeserializeObject <JArray>(gr2.Data.ToString()); if (jarr.Count > 0) { byte[] bytes = Convert.FromBase64String(jarr[0]["dataValue"].ToString().Replace(" ", "+")); string dataValue = Encoding.Default.GetString(bytes); JObject data_jo = JsonConvert.DeserializeObject <JObject>(dataValue); re_jo_body["zzsybsbSbbdxxVO"] = data_jo["zzsybsbSbbdxxVO"]; } } JObject nsrxx_jo = GTXMethod.getNsrxx((JObject)re_jo_body["qcs"]["initData"]["nsrjbxx"]); re_jo_body["qcs"]["initData"]["nsrjbxx"] = nsrxx_jo; re_jo["body"] = re_jo_body; return(re_jo); }
public JObject getGHJFData(JObject j) { JObject re_jo = new JObject(j); string str = System.IO.File.ReadAllText(Server.MapPath("xInitData.quarter.json")); re_jo = JsonConvert.DeserializeObject <JObject>(str); JObject re_jo_body = new JObject(); re_jo_body = JsonConvert.DeserializeObject <JObject>(re_jo["body"].ToString()); string id = ""; string tbrq = ""; string rqQ = ""; string rqZ = ""; GTXResult resultq = GTXMethod.GetGuiZhouYSBQC(); if (resultq.IsSuccess) { List <GDTXGuiZhouUserYSBQC> ysbqclist = JsonConvert.DeserializeObject <List <GDTXGuiZhouUserYSBQC> >(resultq.Data.ToString()); if (ysbqclist.Count > 0) { foreach (GDTXGuiZhouUserYSBQC item in ysbqclist) { if (item.BDDM == this.BDDM) { id = item.Id.ToString(); tbrq = item.HappenDate; rqQ = item.SKSSQQ; rqZ = item.SKSSQZ; } } } } re_jo_body["fxmtysbbdVO"]["fxmtySbb"]["sbbhead"]["sbrq1"] = tbrq; re_jo_body["fxmtysbbdVO"]["fxmtySbb"]["sbbhead"]["skssqq"] = rqQ; re_jo_body["fxmtysbbdVO"]["fxmtySbb"]["sbbhead"]["skssqz"] = rqZ; re_jo_body["qcs"]["formContent"]["sbTysb"]["body"]["sbxxGrid"]["sbxxGridlb"][0]["skssqq"] = rqQ; re_jo_body["qcs"]["formContent"]["sbTysb"]["body"]["sbxxGrid"]["sbxxGridlb"][0]["skssqz"] = rqZ; GTXResult gr1 = GTXMethod.GetCompany(); if (gr1.IsSuccess) { JObject jo = new JObject(); jo = JsonConvert.DeserializeObject <JObject>(gr1.Data.ToString()); if (jo.HasValues) { JObject data_jo = jo; re_jo_body["fxmtysbbdVO"]["fxmtySbb"]["sbbhead"]["nsrmc"] = data_jo["NSRMC"]; re_jo_body["fxmtysbbdVO"]["fxmtySbb"]["sbbhead"]["nsrsbh"] = data_jo["NSRSBH"]; } } GTXResult gr = GTXMethod.GetUserReportData(id, "399001010"); if (gr.IsSuccess) { JArray jarr = new JArray(); jarr = JsonConvert.DeserializeObject <JArray>(gr.Data.ToString()); if (jarr.Count > 0) { byte[] bytes = Convert.FromBase64String(jarr[0]["dataValue"].ToString().Replace(" ", "+")); string dataValue = Encoding.Default.GetString(bytes); JObject data_jo = JsonConvert.DeserializeObject <JObject>(dataValue); JArray data_ja = (JArray)data_jo["fxmtysbbdVO"]["fxmtySbb"]["sbxxGrid"]["sbxxGridlb"]; JArray mxxx = (JArray)re_jo_body["qcs"]["formContent"]["sbTysb"]["body"]["sbxxGrid"]["sbxxGridlb"]; for (int i = 0; i < data_ja.Count; i++) { //mxxx[i]["skssqq"] = data_ja[i]["sfkssqq"]; //mxxx[i]["skssqz"] = data_ja[i]["sfkssqz"]; mxxx[i]["ysx"] = data_ja[i]["ysx"]; mxxx[i]["kce"] = data_ja[i]["jcx"]; mxxx[i]["yssdl"] = data_ja[i]["yssdl"]; mxxx[i]["jsyj"] = data_ja[i]["jsfyj"]; mxxx[i]["sl"] = data_ja[i]["sflhdwse"]; mxxx[i]["sskcs"] = data_ja[i]["sskcs"]; mxxx[i]["ynse"] = data_ja[i]["bqynsfe"]; mxxx[i]["jmse"] = data_ja[i]["bqjmsfe"]; mxxx[i]["yjse"] = data_ja[i]["bqyjsfe"]; mxxx[i]["ysbse"] = data_ja[i]["bqybtsfe"]; } re_jo_body["qcs"]["formContent"]["sbTysb"]["body"]["sbxxGrid"]["sbxxGridlb"] = mxxx; } } re_jo["body"] = re_jo_body; return(re_jo); }
public JObject extractSB_ZZS_YBNSR() { JObject re_json = new JObject(); string str = System.IO.File.ReadAllText(System.Web.HttpContext.Current.Server.MapPath("extractSB_ZZS_YBNSR.json")); re_json = JsonConvert.DeserializeObject <JObject>(str); string id = ""; GTXResult resultq = GTXMethod.GetGuangXiYSBQC(); if (resultq.IsSuccess) { List <GDTXGuangXiUserYSBQC> ysbqclist = JsonConvert.DeserializeObject <List <GDTXGuangXiUserYSBQC> >(resultq.Data.ToString()); if (ysbqclist.Count > 0) { foreach (GDTXGuangXiUserYSBQC item in ysbqclist) { if (item.BDDM == "YBNSRZZS") { id = item.Id.ToString(); } } } } GTXResult gr = GTXMethod.GetUserReportData(id, "101011034"); if (gr.IsSuccess) { JArray jarr = new JArray(); jarr = JsonConvert.DeserializeObject <JArray>(gr.Data.ToString()); if (jarr.Count > 0) { byte[] bytes = Convert.FromBase64String(jarr[0]["dataValue"].ToString().Replace(" ", "+")); string dataValue = Encoding.Default.GetString(bytes); JObject data_json = JsonConvert.DeserializeObject <JObject>(dataValue); if (data_json.HasValues) { JArray data_body = (JArray)data_json["BODY"]; JArray re_body = (JArray)re_json["data"]["BODY"]; double YBHW_LW_BYS_1 = double.Parse(data_body[0]["COL09"].ToString()) + double.Parse(data_body[3]["COL09"].ToString()); re_body[0]["YBHW_LW_BYS"] = new JValue(YBHW_LW_BYS_1); double YBHW_LW_BYS_4 = double.Parse(data_body[0]["COL07"].ToString()) + double.Parse(data_body[1]["COL07"].ToString()) + double.Parse(data_body[3]["COL07"].ToString()) + double.Parse(data_body[4]["COL07"].ToString()); re_body[3]["YBHW_LW_BYS"] = new JValue(YBHW_LW_BYS_4); double YBHW_LW_BYS_7 = double.Parse(data_body[19]["COL03"].ToString()); re_body[6]["YBHW_LW_BYS"] = new JValue(YBHW_LW_BYS_7); double YBHW_LW_BYS_8 = double.Parse(data_body[21]["COL03"].ToString()); re_body[7]["YBHW_LW_BYS"] = new JValue(YBHW_LW_BYS_8); double YBHW_LW_BYS_11 = double.Parse(data_body[0]["COL10"].ToString()) + double.Parse(data_body[1]["COL10"].ToString()) + double.Parse(data_body[2]["COL10"].ToString()) + double.Parse(data_body[3]["COL10"].ToString()) + double.Parse(data_body[4]["COL10"].ToString()) + double.Parse(data_body[5]["COL10"].ToString()); re_body[10]["YBHW_LW_BYS"] = new JValue(YBHW_LW_BYS_11); double YBHW_LW_BYS_21 = double.Parse(data_body[8]["COL10"].ToString()) + double.Parse(data_body[9]["COL10"].ToString()) + double.Parse(data_body[10]["COL10"].ToString()) + double.Parse(data_body[11]["COL10"].ToString()) + double.Parse(data_body[12]["COL10"].ToString()) + double.Parse(data_body[13]["COL10"].ToString()); re_body[20]["YBHW_LW_BYS"] = new JValue(YBHW_LW_BYS_21); } } } GTXResult gr2 = GTXMethod.GetUserReportData(id, "101011035"); if (gr2.IsSuccess) { JArray jarr = new JArray(); jarr = JsonConvert.DeserializeObject <JArray>(gr2.Data.ToString()); if (jarr.Count > 0) { byte[] bytes = Convert.FromBase64String(jarr[0]["dataValue"].ToString().Replace(" ", "+")); string dataValue = Encoding.Default.GetString(bytes); JObject data_json = JsonConvert.DeserializeObject <JObject>(dataValue); if (data_json.HasValues) { JArray data_body = (JArray)data_json["BODY"]; JArray re_body = (JArray)re_json["data"]["BODY"]; double YBHW_LW_BYS_12 = double.Parse(data_body[12]["SE"].ToString()); re_body[11]["YBHW_LW_BYS"] = new JValue(YBHW_LW_BYS_12); double YBHW_LW_BYS_14 = double.Parse(data_body[15]["FS"].ToString()); re_body[13]["YBHW_LW_BYS"] = new JValue(YBHW_LW_BYS_14); } } } return(re_json); }