public static void checkConfigSession()
{
if (HttpContext.Current.Session["IsProduction"] == null)
{
clsDB DB = new clsDB();
SetConfigSession(DB.getDS("SELECT * FROM [config].[appSettings]").Tables[0], null, DB);
}
}
public static string[] getExportHeader(clsDB DB, string channel, string project, string projectGroup, string states, string status1, string status2, bool isIncludeStatus)
{
string sReturn = "";
DataSet ds = DB.getDS("rdb_getHeader '" + channel + "','" + project + "','" + projectGroup + "','" + states + "','" + status1 + "','" + status2 + "'", true);
DataTable dt;
dt = ds.Tables[2];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "Chase List~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^Project~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
dt = ds.Tables[1];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^LOB~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
dt = ds.Tables[3];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^States~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
if (isIncludeStatus)
{
dt = ds.Tables[4];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^Retrieval Chase Status~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
dt = ds.Tables[5];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^Retrieval Chase Detail~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
///////////////////////
dt = ds.Tables[6];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^Invoice Chase Status~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
dt = ds.Tables[7];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^Invoice Chase Detail~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
///////////////////////
dt = ds.Tables[8];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^Coding Chase Status~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
dt = ds.Tables[9];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^Coding Chase Detail~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
///////////////////////
dt = ds.Tables[10];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^QA Coding Chase Status~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
dt = ds.Tables[11];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)
{
sReturn += "^QA Coding Chase Detail~";
}
else
{
sReturn += ", ";
}
sReturn += lib.cStr(dt.Rows[i][0]);
}
}
return(sReturn.Split('^'));
}