public void InsertReport(trpexrpdf obj, List <trpexrpdd> list) { try { using (TransactionScope scope = new TransactionScope()) { //insert DoInsert <trpexrpdf>(obj); for (int i = 0; i < list.Count; i++) { DoInsert <trpexrpdd>(list[i]); } scope.Complete(); } } catch (UtilException ex) { throw ex; } catch (Exception ex) { throw new UtilException(ex.Message, ex); } }
public void loadReportDef() { string record = this.Request["record"]; //rpcd rpexrpdpBll bll = new rpexrpdpBll(); trpexrpdf def = bll.GetSelectedObject <trpexrpdf>(new List <ColumnInfo>() { new ColumnInfo() { ColumnName = "rpcd", ColumnValue = record } }); List <trpexrpdd> lstDtl = bll.GetSelectedRecords <trpexrpdd>(new List <ColumnInfo>() { new ColumnInfo() { ColumnName = "rpcd", ColumnValue = record }, new ColumnInfo() { ColumnName = "isqr", ColumnValue = "Y" } }); string message = "{status:'success',msg:'" + responseJson(def, lstDtl).Replace("'", "\\'") + "'}"; Response.Write(message); }
public void getNew() { string message = "{}"; try { string record = this.Request["record"]; Hashtable ht = JavaScriptConvert.DeserializeObject <Hashtable>(record); List <ColumnInfo> parameters = JavaScriptConvert.DeserializeObject <List <ColumnInfo> >(ht["keycolumns"].ToString()); trpexrpdf obj = JavaScriptConvert.DeserializeObject <trpexrpdf>(ht["params"].ToString()); List <trpexrpdd> listDtl = JavaScriptConvert.DeserializeObject <List <trpexrpdd> >(ht["dtlparams"].ToString()); rpexrpdfBll bll = new rpexrpdfBll(); bll.InsertReport(obj, listDtl); message = "{status:'success',msg:'" + HRMSRes.Public_Message_EditWell + "'}"; } catch (Exception ex) { message = "{status:'failure',msg:'" + ExceptionPaser.Parse(HRMSRes.Public_Message_EditBad, ex, true) + "'}"; } Response.Write(message); }
private string responseJson(trpexrpdf def, List <trpexrpdd> lstDtl) { StringBuilder json = new StringBuilder(); string columnCfg = columnsJson(lstDtl); json.Append("{") .Append("columns:").Append(columnCfg).Append(",") .Append("rpcd:\"").Append(def.rpcd).Append("\"").Append("") .Append("}"); return(json.ToString()); }
public void UpdateReport(trpexrpdf obj, List <trpexrpdd> list) { try { using (TransactionScope scope = new TransactionScope()) { //delete first List <ColumnInfo> parameters = new List <ColumnInfo>() { new ColumnInfo() { ColumnName = "rpcd", ColumnValue = obj.rpcd } }; //DoMultiDelete<tatrosdtl>(parameters); List <trpexrpdd> oldList = GetSelectedRecords <trpexrpdd>(parameters); for (int i = 0; i < oldList.Count; i++) { DoDelete <trpexrpdd>(oldList[i]); } //update DoUpdate <trpexrpdf>(obj, parameters); for (int i = 0; i < list.Count; i++) { DoInsert <trpexrpdd>(list[i]); } scope.Complete(); } } catch (UtilException ex) { throw ex; } catch (Exception ex) { throw new UtilException(ex.Message, ex); } }
public void DeleteReport(List <ColumnInfo> _parameters) { try { using (TransactionScope scope = new TransactionScope()) { trpexrpdf obj = GetSelectedObject <trpexrpdf>(_parameters); DoMultiDelete <trpexrpdd>(_parameters); DoDelete <trpexrpdf>(obj); scope.Complete(); } } catch (UtilException ex) { throw ex; } catch (Exception ex) { throw new UtilException(ex.Message, ex); } }
private void LoadData(string rpcd, List <ColumnInfo> lstParameters) { BaseBll bll = new BaseBll(); trpexrpdf def = bll.GetSelectedObject <trpexrpdf>(new List <ColumnInfo>() { new ColumnInfo() { ColumnName = "rpcd", ColumnValue = rpcd } }); List <trpexrpdd> lstDtl = bll.GetSelectedRecords <trpexrpdd>(new List <ColumnInfo>() { new ColumnInfo() { ColumnName = "rpcd", ColumnValue = rpcd } }); rpexrpdpBll rpbll = new rpexrpdpBll(); DataSet ds = null; switch (def.rpty) { case "Personnel": ds = rpbll.GetPersonalData(rpcd, lstDtl, lstParameters); break; case "Payroll": ds = rpbll.GetPayrollData(rpcd, lstDtl, lstParameters); break; case "PayrollBankAlloc": ds = rpbll.GetPayrollBankAllocData(rpcd, lstDtl, lstParameters); break; } if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { //Title this.GridView1.Caption = "<B>" + def.rptt + "</B>"; this.GridView1.DataSource = ds; this.GridView1.DataBind(); //Merge Column MergeGridView mergeGV = new MergeGridView(); for (int i = 0; i < lstDtl.Count; i++) { if (lstDtl[i].isme == "Y") { mergeGV.Merge(this.GridView1, i); } } //Summary var q = (from p in lstDtl where p.issu == "Y" select p).ToList(); for (int i = 0; i < q.Count; i++) { //GridViewSummary sum = new GridViewSummary(q[i].itnm, SummaryOperation.Sum); } } else { } }