public RunToKFJADCB(int year, int month)
{
this.Year = year;
this.Month = month;
sqldbh = Hanbell.DBUtility.DbHelperManager.CreateDbHelper(Hanbell.DBUtility.DbHelperType.SqlClient);
connSql = sqldbh.GetConnection(ConstrSql);
dbhC = Hanbell.DBUtility.DbHelperManager.CreateDbHelper(Hanbell.DBUtility.DbHelperType.Sybase);
connSybaseC = dbhC.GetConnection(ConstrC);
dbhG = Hanbell.DBUtility.DbHelperManager.CreateDbHelper(Hanbell.DBUtility.DbHelperType.Sybase);
connSybaseG = dbhG.GetConnection(ConstrG);
dbhJ = Hanbell.DBUtility.DbHelperManager.CreateDbHelper(Hanbell.DBUtility.DbHelperType.Sybase);
connSybaseJ = dbhJ.GetConnection(ConstrJ);
dbhN = Hanbell.DBUtility.DbHelperManager.CreateDbHelper(Hanbell.DBUtility.DbHelperType.Sybase);
connSybaseN = dbhN.GetConnection(ConstrN);
this.SetWarehNot();
}
/// <summary>
/// 得到非R系列其他产品所有
/// </summary>
/// <returns></returns>
public DataSet GetResultOther()
{
string ConstrC = Hanbell.DBUtility.PubConstant.GetConnectionString("connection1");
dbhC = Hanbell.DBUtility.DbHelperManager.CreateDbHelper(Hanbell.DBUtility.DbHelperType.Sybase);
connSybaseC = dbhC.GetConnection(ConstrC);
string sql = string.Format("select * from bsc_tb_mfservice where year={0}", RptDatetime.Year);
DataTable dt = dbhC.Query(connSybaseC, sql);
DataSet ds = new DataSet();
DataTable dt_aa_mb = SetAA_MB();
DataTable dt_aa_sj = SetAA_SJ(dt);
DataTable dt_aa_kzl = SetAA_KZL(dt_aa_mb, dt_aa_sj);
DataTable dt_ah_mb = SetAH_MB();
DataTable dt_ah_sj = SetAH_SJ(dt);
DataTable dt_ah_kzl = SetAH_KZL(dt_ah_mb, dt_ah_sj);
DataTable dt_p_mb = SetP_MB();
DataTable dt_p_sj = SetP_SJ(dt);
DataTable dt_p_kzl = SetP_KZL(dt_p_mb, dt_p_sj);
DataTable dt_cm_mb = SetCM_MB();
DataTable dt_cm_sj = SetCM_SJ(dt);
DataTable dt_cm_kzl = SetCM_KZL(dt_cm_mb, dt_cm_sj);
ds.Tables.Add(dt_aa_mb);
ds.Tables.Add(dt_aa_sj);
ds.Tables.Add(dt_aa_kzl);
ds.Tables.Add(dt_ah_mb);
ds.Tables.Add(dt_ah_sj);
ds.Tables.Add(dt_ah_kzl);
ds.Tables.Add(dt_p_mb);
ds.Tables.Add(dt_p_sj);
ds.Tables.Add(dt_p_kzl);
ds.Tables.Add(dt_cm_mb);
ds.Tables.Add(dt_cm_sj);
ds.Tables.Add(dt_cm_kzl);
return(ds);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
private DataTable SetR_SJ()
{
string ConstrC = Hanbell.DBUtility.PubConstant.GetConnectionString("connection1");
dbhC = Hanbell.DBUtility.DbHelperManager.CreateDbHelper(Hanbell.DBUtility.DbHelperType.Sybase);
connSybaseC = dbhC.GetConnection(ConstrC);
string sql = string.Format("select * from bsc_tb_mfservice where year={0}", RptDatetime.Year);
DataTable dt = dbhC.Query(connSybaseC, sql);
DataTable dtR_SJ = BuildTB("R_SJ");
this.SetDB_R_SJ("R", "HD", RptDatetime.Year, dtR_SJ, dt, "SJ_RHD");
this.SetDB_R_SJ("R", "NJ", RptDatetime.Year, dtR_SJ, dt, "SJ_RNJ");
this.SetDB_R_SJ("R", "HB", RptDatetime.Year, dtR_SJ, dt, "SJ_RHB");
this.SetDB_R_SJ("R", "HN", RptDatetime.Year, dtR_SJ, dt, "SJ_RHN");
this.SetDB_R_SJ("R", "CQ", RptDatetime.Year, dtR_SJ, dt, "SJ_RCQ");
SetDBAddByNum(dtR_SJ, new int[5] {
1, 2, 3, 4, 5
}, "SJ_DY"); //当月
SetDBLJByNum(dtR_SJ, 6, "SJ_LJ"); //累计
return(dtR_SJ);
}
public DataSet GetResult()
{
string ConstrC = Hanbell.DBUtility.PubConstant.GetConnectionString("connection1");
dbhC = Hanbell.DBUtility.DbHelperManager.CreateDbHelper(Hanbell.DBUtility.DbHelperType.Sybase);
connSybaseC = dbhC.GetConnection(ConstrC);
string sql = string.Format("select * from bsc_tb_mfservicejad where year={0}", RptDatetime.Year);
DataTable dt = dbhC.Query(connSybaseC, sql);
DataSet ds = new DataSet();
DataTable dtr = this.GetR(dt);
DataTable dtaa = this.GetAA(dt);
DataTable dtah = this.GetAH(dt);
DataTable dtp = this.GetP(dt);
DataTable dtcm = this.GetCM(dt);
DataTable dtall = this.GetALL(dt);
ds.Tables.Add(dtr);
ds.Tables.Add(dtaa);
ds.Tables.Add(dtah);
ds.Tables.Add(dtp);
ds.Tables.Add(dtcm);
ds.Tables.Add(dtall);
return(ds);
}
