//建立各區物流箱產出完成時間區塊
private void BindCATEGORY02()
{
CGDModel.VDS_CGD38_BCO BCO = new CGDModel.VDS_CGD38_BCO(ConntionDB);
ParameterList.Clear();
ParameterList.Add("02");
DataTable dt = BCO.QueryVDS_CGD_CODE_DETL(ParameterList);
DataTable TempTable = new DataTable();
TempTable.Columns.Add(new DataColumn("TITLE"));
TempTable.Columns.Add(new DataColumn("SCODE"));
TempTable.Columns.Add(new DataColumn("EXPLAIN"));
TempTable.Columns.Add(new DataColumn("FINISH_TIME"));
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = TempTable.NewRow();
int iNo = i + 1;
dr["TITLE"] = iNo.ToString() + "、" + dt.Rows[i]["EXPLAIN"].ToString();
dr["SCODE"] = dt.Rows[i]["SCODE"].ToString();
dr["EXPLAIN"] = dt.Rows[i]["EXPLAIN"].ToString();
string strFINISH_TIME = "";
if (hdfID.Value != "")
{
ParameterList.Clear();
ParameterList.Add(hdfID.Value);
ParameterList.Add(DBNull.Value);
DataTable dtData = BCO.QueryVDS_CGD_DAILY_AREA(ParameterList);
DataRow[] drFind = dtData.Select("SCODE='" + dr["SCODE"].ToString() + "'");
if (drFind.Length > 0)
{
strFINISH_TIME = drFind[0]["FINISH_TIME"].ToString();
}
}
dr["FINISH_TIME"] = strFINISH_TIME;
TempTable.Rows.Add(dr);
}
DataList2.DataSource = TempTable;
DataList2.DataBind();
Session["CGD38_CATEGORY02_" + PageTimeStamp.Value] = TempTable;
}
