private string execute(salsum s)
{
SqlDbAccess dbAccess = new SqlDbAccess(PKDBHelper.ConnectString);
dbAccess.CommandTimeout = 120;
string jsonset = string.Empty;
if (("{SLT}{SLT2}{SLT3}").IndexOf("{" + s.rmode + "}") >= 0)
{
string query = @"MBL_SALSUM_Q1";
SqlParamCollection parameters = new SqlParamCollection();
PKDBHelper.SqlAddParam(parameters, "@INFDS", SqlDbType.VarChar, 100, s.infds);
PKDBHelper.SqlAddParam(parameters, "@RTNCD", SqlDbType.VarChar, 100, s.rtncd);
PKDBHelper.SqlAddParam(parameters, "@RMODE", SqlDbType.VarChar, 20, s.rmode);
PKDBHelper.SqlAddParam(parameters, "@TDATE", SqlDbType.VarChar, 8, s.tdate);
PKDBHelper.SqlAddParam(parameters, "@SLTTG", SqlDbType.VarChar, 10, s.slttg);
DataTable dt = dbAccess.ExecuteSpDataSet(query, parameters).Tables[0];
if (dt.Rows.Count > 0)
{
return JsonConvert.SerializeObject(dt); //, Formatting.Indented);
}
else
{
return string.Empty;
}
}
else
{
return string.Empty;
}
}
public string GetDailyOrderReport(string tdate)
{
salsum sal = new salsum();
sal.tdate = tdate;
sal.rmode = "SLT2";
return execute(sal);
}
public string GetProductionLoad(string tdate)
{
salsum sal = new salsum();
sal.tdate = tdate;
sal.slttg = "RPT07";
sal.rmode = "SLT";
return execute(sal);
}
public string GetDeliveryLoad(string tdate)
{
salsum sal = new salsum();
sal.tdate = tdate;
sal.slttg = "RPT02";
sal.rmode = "SLT";
return execute(sal);
}
public string GetDailySaleReport(string tdate)
{
salsum sal = new salsum();
sal.tdate = tdate;
sal.slttg = "RPT01";
sal.rmode = "SLT";
return execute(sal);
}
