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); }