protected override void Init()
{
base.Init();
nc = new NianDuCaiGouPaiMingConfig_HS(DBServerType.SybaseASE, "HansonERP", this.ToString());
nc.InitData();
nc.ConfigData();
string[] title = { "年度", "厂商代号", "厂商简称", "上月采购金额(万元)", "上月排名", "年度累计采购金额(万元)", "年度排名", "同期累计采购金额(万元)", "同期排名", "去年总采购金额(万元)", "去年排名", "較去年成長金額", "成长率", "厂商类别" };
int[] width = { 80, 150, 150, 100, 70, 150, 70, 200, 70, 150, 70, 100, 60, 120 };
DataTable dt = nc.GetDataTable("ndcgpm");
//获取較去年成長金額
foreach (DataRow item in dt.Rows)
{
item["ly_grow"] = (Convert.ToDouble(item["y_puramt"].ToString()) - Convert.ToDouble(item["lm_puramt"].ToString())).ToString("0.00");
item["ly_grower"] = ((Convert.ToDouble(item["y_puramt"].ToString()) - Convert.ToDouble(item["lm_puramt"].ToString())) / Convert.ToDouble(item["lm_puramt"].ToString())).ToString("0.00%");
}
foreach (DataRow item in dt.Rows)
{
item["ly_grower"] = "<p align=right>" + item["ly_grower"] + "</p>";
if (item["ly_grower"].ToString().Contains("-"))
{
item["ly_grower"] = "<font color=red>" + item["ly_grower"] + "</font>";
}
}
//<--2021/1/26增加厂商类别
dt.Columns.Add("type", System.Type.GetType("System.String")); //插入新列
DataTable dtType = getVdrType(); //拿到有厂商类别的dt
foreach (DataRow item in dt.Rows)
{
DataRow[] typeRow = dtType.Select("vdrno='" + item["vdrno"].ToString() + "'");//拿到这个厂商的类型集合
if (typeRow != null)
{
string[] a = typeRow.Select(row => row["Name"].ToString()).ToArray(); //DataRow[] 转成 string[]
string type = string.Join(";", a); //转成string字符串
item["type"] = type;
}
}
//-->
dt.AcceptChanges();
this.content = GetContent(dt, title, width);
if (nc.GetDataTable("ndcgpm").Rows.Count > 0)
{
AddNotify(new MailNotify());
}
}
protected override void Init()
{
base.Init();
nc = new SHBNianDuCaiGouPaiMingConfig(DBServerType.SybaseASE, "SHBERP", this.ToString());
nc.InitData();
nc.ConfigData();
NotificationConfig ncComer = new ComerNainDuCaiGouMaiMingConfig(DBServerType.SybaseASE, "ComerERP", this.ToString());
ncComer.InitData();
ncComer.ConfigData();
NotificationConfig ncHanson = new NianDuCaiGouPaiMingConfig_HS(DBServerType.SybaseASE, "HansonERP", this.ToString());
ncHanson.InitData();
ncHanson.ConfigData();
string[] title = { "年度", "厂商代号", "厂商简称", "上月采购金额(万元)", "上月排名", "年度累计采购金额(万元)", "年度排名", "同期累计采购金额(万元)", "同期排名", "去年总采购金额(万元)", "去年排名", "較去年成長金額", "成长率", "厂商类别" };
int[] width = { 80, 150, 150, 100, 70, 150, 70, 200, 70, 150, 70, 100, 60, 120 };
DataTable dt1 = nc.GetDataTable("ndcgpm");
DataTable dt2 = ncComer.GetDataTable("ndcgpm");
DataTable dt3 = ncHanson.GetDataTable("ndcgpm");
//获取較去年成長金額
foreach (DataRow item in dt1.Rows)
{
item["ly_grow"] = (Convert.ToDouble(item["y_puramt"].ToString()) - Convert.ToDouble(item["lm_puramt"].ToString())).ToString("0.00");
item["ly_grower"] = ((Convert.ToDouble(item["y_puramt"].ToString()) - Convert.ToDouble(item["lm_puramt"].ToString())) / Convert.ToDouble(item["lm_puramt"].ToString())).ToString("0.00%");
}
foreach (DataRow item in dt1.Rows)
{
item["ly_grower"] = "<p align=right>" + item["ly_grower"] + "</p>";
if (item["ly_grower"].ToString().Contains("-"))
{
item["ly_grower"] = "<font color=red>" + item["ly_grower"] + "</font>";
}
}
foreach (DataRow item in dt2.Rows)
{
item["ly_grow"] = (Convert.ToDouble(item["y_puramt"].ToString()) - Convert.ToDouble(item["ly_puramt"].ToString())).ToString("0.00");
item["ly_grower"] = ((Convert.ToDouble(item["y_puramt"].ToString()) - Convert.ToDouble(item["ly_puramt"].ToString())) / Convert.ToDouble(item["lm_puramt"].ToString())).ToString("0.00%");
}
foreach (DataRow item in dt2.Rows)
{
item["ly_grower"] = "<p align=right>" + item["ly_grower"] + "</p>";
if (item["ly_grower"].ToString().Contains("-"))
{
item["ly_grower"] = "<font color=red>" + item["ly_grower"] + "</font>";
}
}
foreach (DataRow item in dt3.Rows)
{
item["ly_grow"] = (Convert.ToDouble(item["y_puramt"].ToString()) - Convert.ToDouble(item["ly_puramt"].ToString())).ToString("0.00");
item["ly_grower"] = ((Convert.ToDouble(item["y_puramt"].ToString()) - Convert.ToDouble(item["ly_puramt"].ToString())) / Convert.ToDouble(item["lm_puramt"].ToString())).ToString("0.00%");
}
foreach (DataRow item in dt3.Rows)
{
item["ly_grower"] = "<p align=right>" + item["ly_grower"] + "</p>";
if (item["ly_grower"].ToString().Contains("-"))
{
item["ly_grower"] = "<font color=red>" + item["ly_grower"] + "</font>";
}
}
dt1.AcceptChanges();
dt2.AcceptChanges();
dt3.AcceptChanges();
DataTable cdt = addType(dt1, "C");
DataTable kdt = addType(dt2, "K");
DataTable hdt = addType(dt3, "H");
this.content = GetContent(cdt, kdt, hdt, title, width);
if (nc.GetDataTable("ndcgpm").Rows.Count > 0 && ncComer.GetDataTable("ndcgpm").Rows.Count > 0)
{
AddNotify(new MailNotify());
}
}
