public void OnBeforeExport(object sender, Ede.Uof.Utility.Component.BeforeExportEventArgs e)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @" SELECT [MANU],[CLINET],CONVERT(NVARCHAR,[MANUDATE],112) AS MANUDATE,[MOCMANULINE].[MB002],CONVERT(INT,(ISNULL([PACKAGE],0))) AS PACKAGE,ISNULL([NUM],0) AS NUM,MB004
FROM [TKMOC].[dbo].[MOCMANULINE]
LEFT JOIN [TK].dbo.INVMB ON INVMB.MB001=[MOCMANULINE].MB001
WHERE CONVERT(NVARCHAR,[MANUDATE],112)>=@SDATE AND CONVERT(NVARCHAR,[MANUDATE],112)<=@EDATE
AND (NUM>0 OR [PACKAGE]>0)
ORDER BY [MANU],[MANUDATE],[CLINET],[MB002]
";
m_db.AddParameter("@SDATE", txtDate1.Text);
m_db.AddParameter("@EDATE", txtDate2.Text);
DataTable dt = new DataTable();
dt.Load(m_db.ExecuteReader(cmdTxt));
if (dt.Rows.Count > 0)
{
dt.Columns[0].Caption = "預排-線別";
dt.Columns[1].Caption = "客戶";
dt.Columns[2].Caption = "預計生產日期";
dt.Columns[3].Caption = "品名";
dt.Columns[4].Caption = "包裝數";
dt.Columns[5].Caption = "重量";
e.Datasource = dt;
}
}
public void OnBeforeExport(object sender, Ede.Uof.Utility.Component.BeforeExportEventArgs e)
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string STATUS = DropDownList1.Text;
string cmdTxt = @" SELECT [SERNO],[PROJECTNO],[PROJECTNAME],[ONLINEFINISH],[PAPERFINISH],[MEMO],[PROJECTSTATUS],[ID] FROM [TKRESEARCH].[dbo].[TBPROJECT] WHERE PROJECTSTATUS=@STATUS ORDER BY PROJECTSTATUS,SERNO ";
m_db.AddParameter("@STATUS", STATUS);
DataTable dt = new DataTable();
dt.Load(m_db.ExecuteReader(cmdTxt));
if (dt.Rows.Count > 0)
{
dt.Columns[0].Caption = "編號";
dt.Columns[1].Caption = "專案編號";
dt.Columns[2].Caption = "專案名稱";
dt.Columns[3].Caption = "線上校稿完成";
dt.Columns[4].Caption = "紙本簽核完成";
dt.Columns[5].Caption = "備註";
dt.Columns[6].Caption = "狀態";
e.Datasource = dt;
}
}
