//Bulk Add PublicJsonresult Pladd (stringCountstringR_time,stringR_SB,stringR_FL,stringKSRQ,stringJSRQ,stringSSRQ) { stringTbsql ="SELECT * from Sys_rpt_list WHERE tcategory="+ R_time +"and isreport="+ R_SB +"and pcategory="+R_FL; DataTable TB= Dbhelperyw.query (Tbsql). tables[0]; //Delete account DataDelete (SSRQ, KSRQ, JSRQ); //perform the accounting data generation processExecuteproc ("proc_tz_forward_report_2nd", Ssrq, KSRQ, JSRQ); intc =0; stringR =""; Try { foreach(DataRow IteminchTB. Rows) {//get report structure data stringJGTB = item["Structfile"]. ToString ();//JGTB50010//Get Report Data stringDATATB = item["datafile"]. ToString ();//TB50010//Instantiate report structure, data processing, method parameter matchingStatisticsofbusinessunit Statisticsofbusinessunit =NewStatisticsofbusinessunit (JGTB, DATATB, Ksrq, JSRQ, SSRQ,false); //overlay data that needs to be importedc + =statisticsofbusinessunit.exportlocal (); } //working with totals, subtotals in a report//Executeproc ("Proc_tz_forward_update2", Ssrq, Ksrq, JSRQ); stringTbname = Dbhelperyw.query (tbsql). tables[0]. rows[0]["datafile"]. ToString (). Trim (); if(Tbname = ="TB50010") {Executeproc ("proc_tz_forward_update", Ssrq, KSRQ, JSRQ); } if(Tbname = ="TB5006") {Executeproc ("Proc_tz_forward_update2", Ssrq, KSRQ, JSRQ); } R="[{' Success ': ' Symbiosis has become"+ Count +"Report, Success"+ C +"Zhang, failed"+ (int. Parse (count)-C) +"Zhang! '}]"; } Catch(Exception ex) {R="[{' Susess ': ' Program exception"+ ex. Message +"'}]"; } returnJson (R, Jsonrequestbehavior.allowget); }
Methods for handling structure table functions