Wednesday, 26 February 2014

Excel Column Name Change private Table ExportAllData() { Table table = new Table(); TableRow row = null; //DTVendorDetails = RPT_VITS_VendorDetails(Decrypt(Request.QueryString["Division"].ToString(), strSecurityCode), lblCompanyCode.Text.Trim(), Decrypt(Request.QueryString["Plant"].ToString(), strSecurityCode), txtVendorName.Text.Trim(), txtLogFrom.Text.Trim(), txtLogTo.Text.Trim(), txtBarCode.Text.Trim(), txtVendorNameUnknown.Text.Trim(), txtUser.Text.Trim(), txtPDOCNO.Text.Trim(), string.Empty, txtInvoiceNo.Text.Trim(), ddlStatus.SelectedValue.Trim()); string[] VendorCode = { string.Empty }; string[] companycode = lblCompanyCode.Text.Trim().Split('-'); string selVal = string.Empty; for (int j = 0; j < cblCustomerList.Items.Count; j++) { if (cblCustomerList.Items[j].Selected) { selVal = selVal + "," + cblCustomerList.Items[j].Value.Trim(); } } if (txtVendorName.Text.Length > 0) { VendorCode = txtVendorName.Text.Trim().Split('-'); } //if (txtUser.Text.Length > 0) //{ // string[] sponsor = txtUser.Text.Trim().Split('-'); // DTVendorDetails = RPT_VITS_VendorDetails(Decrypt(Request.QueryString["Division"].ToString(), strSecurityCode), companycode[0].Trim(), Decrypt(Request.QueryString["Plant"].ToString(), strSecurityCode), VendorCode[0].ToString().Trim(), txtLogFrom.Text.Trim(), txtLogTo.Text.Trim(), txtBarCode.Text.Trim(), txtVendorNameUnknown.Text.Trim(), sponsor[0].ToString().Trim(), txtPDOCNO.Text.Trim(), string.Empty, txtInvoiceNo.Text.Trim(), selVal.Trim(), hdnLevel1.Value.Trim(), hdnLevel2.Value.Trim(), hdnLevel3.Value.Trim()); //} //else //{ // DTVendorDetails = RPT_VITS_VendorDetails(Decrypt(Request.QueryString["Division"].ToString(), strSecurityCode), companycode[0].Trim(), Decrypt(Request.QueryString["Plant"].ToString(), strSecurityCode), VendorCode[0].ToString().Trim(), txtLogFrom.Text.Trim(), txtLogTo.Text.Trim(), txtBarCode.Text.Trim(), txtVendorNameUnknown.Text.Trim(), txtUser.Text.Trim(), txtPDOCNO.Text.Trim(), string.Empty, txtInvoiceNo.Text.Trim(), selVal.Trim(), hdnLevel1.Value.Trim(), hdnLevel2.Value.Trim(), hdnLevel3.Value.Trim()); //} objBll.Division = Decrypt(Request.QueryString["Division"].ToString(), strSecurityCode); objBll.Company = companycode[0].Trim(); objBll.Plant = Decrypt(Request.QueryString["Plant"].ToString(), strSecurityCode); objBll.Vendor_Code = VendorCode[0].ToString().Trim(); objBll.Log_From = txtLogFrom.Text.Trim(); objBll.Log_To = txtLogTo.Text.Trim(); objBll.Srlno = txtBarCode.Text.Trim(); objBll.Vendor_Name = txtVendorNameUnknown.Text.Trim(); objBll.User = txtUser.Text.Trim(); objBll.Pdno = txtPDOCNO.Text.Trim(); objBll.Invoice_No = txtInvoiceNo.Text.Trim(); objBll.Approved_By = ""; objBll.App_Status = selVal.Trim(); objBll.LevelCode1 = hdnLevel1.Value.Trim(); objBll.LevelCode2 = hdnLevel2.Value.Trim(); objBll.LevelCode3 = hdnLevel3.Value.Trim(); objBll.SGID = Session["SG_ID"].ToString(); DTVendorDetails = objBll.RPT_VITS_VendorDetails(objBll); // Remove unwanted columns DTVendorDetails.Columns.Remove("UNAME"); DTVendorDetails.Columns.Remove("SGTXT_VEN"); DTVendorDetails.Columns.Remove("BEWTP"); DTVendorDetails.Columns.Remove("XBLNR"); DTVendorDetails.Columns.Remove("APDSTAT"); DTVendorDetails.Columns.Remove("BILLTRACK"); DTVendorDetails.Columns.Remove("ZSABE"); DTVendorDetails.Columns.Remove("CHECT"); DTVendorDetails.Columns.Remove("EXPN"); DTVendorDetails.Columns.Remove("FNAME"); DTVendorDetails.Columns.Remove("URL"); DTVendorDetails.Columns.Remove("BUDAT"); DTVendorDetails.Columns.Remove("LOC"); DTVendorDetails.Columns.Remove("ROW_ID"); DTVendorDetails.Columns.Remove("SERVICE_ENTRY_DT"); DTVendorDetails.Columns.Remove("MYINFO_APPROVAL_DATE"); DTVendorDetails.Columns.Remove("PAYMENT_DATE"); DTVendorDetails.Columns.Remove("ITAD_INDEXNO"); DTVendorDetails.Columns.Remove("AUGDT"); DTVendorDetails.Columns.Remove("DELFLG"); DTVendorDetails.Columns.Remove("EXKEY"); //Add the Headers row = new TableRow(); for (int j = 0; j < DTVendorDetails.Columns.Count; j++) { TableHeaderCell headerCell = new TableHeaderCell(); switch (DTVendorDetails.Columns[j].ColumnName) { case "MANDT": headerCell.Text = "Division"; break; case "BUKRS": headerCell.Text = "Company Code"; break; case "LOGSRL": headerCell.Text = "Login Number"; break; case "LIFNR": headerCell.Text = "Vendor code"; break; case "BELNR": headerCell.Text = "Invoice Number"; break; case "INVOICE_STATUS": headerCell.Text = "Invoice Status"; break; case "INVOICE_DESC": headerCell.Text = "Material/Service"; break; case "LOGDATE": headerCell.Text = "Login Date"; break; case "APNAM": headerCell.Text = "User"; break; case "CGRYFLG": headerCell.Text = "Invoice Category"; break; case "EBELN": headerCell.Text = "Purchase Order"; break; case "BELNR1": headerCell.Text = "Invoice Number"; break; case "DUEDAT": headerCell.Text = "Due date"; break; case "GTOTAL": headerCell.Text = "Exces Duty"; break; case "WODOC": headerCell.Text = "Processing Document"; break; case "INVDT": headerCell.Text = "Invoice Date"; break; case "LIFRE": headerCell.Text = "Invoicing Party"; break; case "TOTAL": headerCell.Text = "Invoice Amount"; break; case "GTOTAL1": headerCell.Text = "Grand Total"; break; case "WMWST": headerCell.Text = "Service Tax"; break; case "REMARKS": headerCell.Text = "Remarks"; break; case "BDC_FLG": headerCell.Text = "Processing Invoice Status"; break; case "AUGBL": headerCell.Text = "Clearing Document"; break; case "VENDET": headerCell.Text = "Vendor Deatails"; break; case "EXCEPTIONS": headerCell.Text = "Exception"; break; case "LOC": headerCell.Text = "Location"; break; case "BUDAT1": headerCell.Text = "Logged Date"; break; case "VENDORNAME": headerCell.Text = "Vendor Name"; break; case "INVPARTYNAME": headerCell.Text = "Invoice Party Name"; break; case "STATUS": headerCell.Text = "Status"; break; case "UTR_NO": headerCell.Text = "UTR Number"; break; case "UTR_DATE": headerCell.Text = "UTR Date"; break; } headerCell.BackColor = System.Drawing.Color.FromName("#FFDD6F"); headerCell.ForeColor = System.Drawing.Color.FromName("#795E00"); row.Cells.Add(headerCell); } table.Rows.Add(row); //Add the Column values for (int i = 0; i < DTVendorDetails.Rows.Count; i++) { row = new TableRow(); for (int j = 0; j < DTVendorDetails.Columns.Count; j++) { TableCell cell = new TableCell(); cell.Text = DTVendorDetails.Rows[i][j].ToString(); row.Cells.Add(cell); } // Add the TableRow to the Table table.Rows.Add(row); } return table; }

No comments:

Post a Comment