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;
}
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment