private void QueryData()
{
#region
try
{
if (s_DIS_NO == "") return;
//if (CurrentPageMode == PageCurrentMode.Insert || CurrentPageMode == PageCurrentMode.Edit)
//{
#region
CheckCurrentIndexAndSwitchNavigator(s_DIS_NO);
ALOModel.MaintainDisMain BCO1 = new ALOModel.MaintainDisMain(ConnectionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(s_DIS_NO == "" ? null : s_DIS_NO);
dtDisMain = BCO1.QueryByDisNo(ParameterList);
ALOModel.MaintainDisCRMRecord BCO2 = new ALOModel.MaintainDisCRMRecord(ConnectionDB);
ParameterList.Clear();
ParameterList.Add(s_DIS_NO == "" ? null : s_DIS_NO);
dtDisItem = BCO2.QueryDisCRMItemByDisNo(ParameterList);
dtDisItemOld = dtDisItem.Copy();
DataColumn[] PrimaryKeys21 = new DataColumn[3];
PrimaryKeys21[0] = dtDisItemOld.Columns["DIS_NO"];
PrimaryKeys21[1] = dtDisItemOld.Columns["ITEM"];
PrimaryKeys21[2] = dtDisItemOld.Columns["PERIOD"];
dtDisItemOld.PrimaryKey = PrimaryKeys21;
DataColumn[] PrimaryKeys22 = new DataColumn[3];
PrimaryKeys22[0] = dtDisItem.Columns["DIS_NO"];
PrimaryKeys22[1] = dtDisItem.Columns["ITEM"];
PrimaryKeys22[2] = dtDisItem.Columns["PERIOD"];
dtDisItem.PrimaryKey = PrimaryKeys22;
ALOModel.MaintainDisStore BCO3 = new ALOModel.MaintainDisStore(ConnectionDB);
ParameterList.Clear();
ParameterList.Add(s_DIS_NO == "" ? null : s_DIS_NO);
dtDisStoreAll = BCO3.QueryDisStoreByDisNo(ParameterList);
dtDisStore = dtDisStoreAll.Copy();
dtDisStoreAllOld = dtDisStoreAll.Copy();
DataColumn[] PrimaryKeys31 = new DataColumn[1];
PrimaryKeys31[0] = dtDisStoreAllOld.Columns["CODE"];
dtDisStoreAllOld.PrimaryKey = PrimaryKeys31;
DataColumn[] PrimaryKeys32 = new DataColumn[1];
PrimaryKeys32[0] = dtDisStoreAll.Columns["CODE"];
dtDisStoreAll.PrimaryKey = PrimaryKeys32;
#region Binding Data
txt_DisNo.Text = s_DIS_NO;
if (dtDisMain != null && dtDisMain.Rows.Count > 0)
{
SLP_StoreChain1.Text = dtDisMain.Rows[0]["RCHAN_NO"].ToString();
SLP_SLPDate1_DisDate.Text = dtDisMain.Rows[0]["DIS_DATE"].ToString();
SLP_SLPDate2_StAcceptDate.Text = dtDisMain.Rows[0]["ST_ACCEPT_DATE"].ToString();
SLP_SLPDate3_TransStAcceptDate.Text = dtDisMain.Rows[0]["TRANS_ST_ACCEPT_DATE"].ToString();
SLP_SLPDate4_ApproveDate.Text = dtDisMain.Rows[0]["APPROVE_DATE"].ToString();
SLP_EnumBase1.Text = dtDisMain.Rows[0]["DATA_SOURCE"].ToString();
txt_POSourceNo.Text = dtDisMain.Rows[0]["PO_SOURCE_NO"].ToString();
}
else
{
CurrentPageMode = PageCurrentMode.Query;
throw new Exception("查無此筆資料或已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!");
}
currentGvModeDisItem = CurrentGridviewMode.ReadOnly;
gv_DisItem.DataSource = dtDisItem;
gv_DisItem.DataBind();
if (dtDisItem != null && dtDisItem.Rows.Count > 0)
{
s_ITEM = dtDisItem.Rows[0]["ITEM"].ToString().Trim(); ;
s_PERIOD = dtDisItem.Rows[0]["PERIOD"].ToString().Trim(); ;
s_ITEM_NAME = dtDisItem.Rows[0]["ITEM_NAME"].ToString().Trim(); ;
s_PMA = dtDisItem.Rows[0]["PMA"].ToString().Trim(); ;
s_ROOT_NO = dtDisItem.Rows[0]["ROOT_NO"].ToString().Trim(); ;
s_PATTERN = dtDisItem.Rows[0]["PATTERN_NO"].ToString().Trim(); ;
}
string strFilter = string.Format(" ITEM='{0}' and PERIOD='{1}' ", s_ITEM, s_PERIOD);
DataView dv = dtDisStoreAll.DefaultView;
dv.RowFilter = strFilter;
dtDisStore = dv.ToTable().Copy();
currentGvModeDisStore = CurrentGridviewMode.ReadOnly;
gv_DisStore.DataSource = dtDisStore;
gv_DisStore.DataBind();
CountGvDisStoreInfo();
#endregion
#endregion
//}
if (CurrentPageMode == PageCurrentMode.Readonly)
{
CheckConfirmOrRemove();
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
