protected void btn_SaveDisSetting_Click(object sender, EventArgs e)
{
#region
try
{
DateTime ProcessingDateTime = DateTime.Now;
string strItem = SLP_SKU1.Text;
string strPeriod = SLP_ItemPeriod1.Text;
string strDisType = SLP_PARAM1.Text;
string strDisDate = SLP_SLPDate1.Text;
string strStAcceptDate = SLP_SLPDate2.Text;
string strUserId = Session["UID"].ToString();
if (strDisType == "109" && (dtDisTypeTmp109 == null || dtDisTypeTmp109.Rows.Count <= 0))
{
//如果Rank類別＝109 且未設定pattern等級設定則不繼續執行
ErrorMsgLabel.Text = "無設定等級資料，請確認配本方式或重新設定";
return;
}
DataTable NewDisChanReferDt = dtDisChanReferFromPOP;
string strChan = "";
if (NewDisChanReferDt != null && NewDisChanReferDt.Rows.Count > 0)
{
//檢核【確認通路參照】之個別通路參照比例是否為100%
if (!CheckChanReferRateIs100(NewDisChanReferDt, out strChan))
{
ErrorMsgLabel.Text = string.Format("通路:{0}參照比率必須為100%!", strChan);
return;
}
}
ALOModel.MaintainDisRecord BCO = new ALOModel.MaintainDisRecord(ConnectionDB);
ALOModel.ALOCommon BCOCommon = new ALOModel.ALOCommon();
System.Data.Common.DbTransaction DBT = BCOCommon.OpenAndGetConnection(ConnectionDB).BeginTransaction();
try
{
SetDisTmpRec(strDisDate, strStAcceptDate, strItem, strPeriod, strDisType, strUserId, ProcessingDateTime);
SetDisItem(strItem, strPeriod, strDisType, strUserId, ProcessingDateTime);
SetDisItemRefer(strUserId, ProcessingDateTime);
SetDisChan(strItem, strPeriod, strStAcceptDate, strDisType, strUserId, ProcessingDateTime);
#region 重新指定PK欄位
if (dtDisChan.PrimaryKey.Length <= 0)
{
DataColumn[] PrimaryKeys32 = new DataColumn[4];
PrimaryKeys32[0] = dtDisChan.Columns["DIS_NO"];
PrimaryKeys32[1] = dtDisChan.Columns["ITEM"];
PrimaryKeys32[2] = dtDisChan.Columns["PERIOD"];
PrimaryKeys32[3] = dtDisChan.Columns["CHAN_NO"];
dtDisChan.PrimaryKey = PrimaryKeys32;
}
if (dtDisItemRefer.PrimaryKey.Length <= 0)
{
DataColumn[] PrimaryKeys42 = new DataColumn[5];
PrimaryKeys42[0] = dtDisItemRefer.Columns["DIS_NO"];
PrimaryKeys42[1] = dtDisItemRefer.Columns["ITEM"];
PrimaryKeys42[2] = dtDisItemRefer.Columns["PERIOD"];
PrimaryKeys42[3] = dtDisItemRefer.Columns["RITEM"];
PrimaryKeys42[4] = dtDisItemRefer.Columns["RPERIOD"];
dtDisItemRefer.PrimaryKey = PrimaryKeys42;
}
if (dtDisTypeTmp109.PrimaryKey.Length <= 0)
{
DataColumn[] PrimaryKeys62 = new DataColumn[6];
PrimaryKeys62[0] = dtDisTypeTmp109.Columns["DIS_NO"];
PrimaryKeys62[1] = dtDisTypeTmp109.Columns["ITEM"];
PrimaryKeys62[2] = dtDisTypeTmp109.Columns["PERIOD"];
PrimaryKeys62[3] = dtDisTypeTmp109.Columns["RANK_CODE"];
PrimaryKeys62[4] = dtDisTypeTmp109.Columns["RANK_LEVEL"];
PrimaryKeys62[5] = dtDisTypeTmp109.Columns["PATTERN_NO"];
dtDisTypeTmp109.PrimaryKey = PrimaryKeys62;
}
#endregion
bool bResult = BCO.UpdateDisRecordFor131(dtDisTmpRec, dtDisTmpRecOld,
dtDisMain, dtDisMainOld, dtDisItem, dtDisItemOld,
dtDisChan, dtDisChanOld, dtDisItemRefer, dtDisItemReferOld,
dtDisTypeTmp109, dtDisType109TmpOld,
dtDisTypeTmp, dtDisTypeTmpOld, NewDisChanReferDt, s_DISNO, strItem, strPeriod, strUserId, strStAcceptDate, DBT);
if (bResult)
{
ALOModel.MaintainDisTmpRec BCO2 = new ALOModel.MaintainDisTmpRec(ConnectionDB);
BCO2.UpdateDisTmpRec(dtDisTmpRec, dtDisTmpRecOld, s_DISNO, DBT);
}
DBT.Commit();//交易成功
}
catch (Exception ex)
{
DBT.Rollback();//交易失敗
throw ex;
}
GetAllOriginalDatatables();
BindingData();
dtDisChanReferFromPOP = null;
ConfirmItemReferPressed = false;
ResultMsgLabel.Text = "更新成功";
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
/// <summary>
/// 取得原始資料庫資料
/// </summary>
private void GetAllOriginalDatatables()
{
#region
try
{
#region
ArrayList ParameterList1 = new ArrayList();//20091106
ParameterList1.Clear();
ParameterList1.Add(s_DISNO);
ParameterList1.Add(s_ITEM);
ParameterList1.Add(s_PERIOD);
ParameterList1.Add(null);//CHAN_NO
#region DIS_MAIN
ALOModel.MaintainDisMain BCO1 = new ALOModel.MaintainDisMain(ConnectionDB);
dtDisMainOld = BCO1.QueryByDisNo(ParameterList1);
dtDisMain = dtDisMainOld.Copy();
DataColumn[] PrimaryKeys11 = new DataColumn[1];
PrimaryKeys11[0] = dtDisMainOld.Columns["DIS_NO"];
dtDisMainOld.PrimaryKey = PrimaryKeys11;
DataColumn[] PrimaryKeys12 = new DataColumn[1];
PrimaryKeys12[0] = dtDisMain.Columns["DIS_NO"];
dtDisMain.PrimaryKey = PrimaryKeys12;
#endregion
#region DIS_ITEM
ALOModel.MaintainDisItem BCO2 = new ALOModel.MaintainDisItem(ConnectionDB);
dtDisItemOld = BCO2.QueryByDisNo(ParameterList1);
dtDisItem = dtDisItemOld.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;
#endregion
#region DIS_CHAN
ALOModel.MaintainDisChan BCO3 = new ALOModel.MaintainDisChan(ConnectionDB);
dtDisChanOld = BCO3.QueryDisChanFor111(ParameterList1);
dtDisChan = dtDisChanOld.Copy();
DataColumn[] PrimaryKeys31 = new DataColumn[4];
PrimaryKeys31[0] = dtDisChanOld.Columns["DIS_NO"];
PrimaryKeys31[1] = dtDisChanOld.Columns["ITEM"];
PrimaryKeys31[2] = dtDisChanOld.Columns["PERIOD"];
PrimaryKeys31[3] = dtDisChanOld.Columns["CHAN_NO"];
dtDisChanOld.PrimaryKey = PrimaryKeys31;
DataColumn[] PrimaryKeys32 = new DataColumn[4];
PrimaryKeys32[0] = dtDisChan.Columns["DIS_NO"];
PrimaryKeys32[1] = dtDisChan.Columns["ITEM"];
PrimaryKeys32[2] = dtDisChan.Columns["PERIOD"];
PrimaryKeys32[3] = dtDisChan.Columns["CHAN_NO"];
dtDisChan.PrimaryKey = PrimaryKeys32;
#endregion
#region DIS_CHAN_REFER
//ALOModel.MaintainDisChanRefer BCO9 = new ALOModel.MaintainDisChanRefer(ConnectionDB);
//dtDisChanReferOld = BCO9.QueryDisChanReferByDisNo(ParameterList1);
//dtDisChanRefer = dtDisChanReferOld.Copy();
//DataColumn[] PrimaryKeys91 = new DataColumn[6];
//PrimaryKeys91[0] = dtDisChanReferOld.Columns["DIS_NO"];
//PrimaryKeys91[1] = dtDisChanReferOld.Columns["ITEM"];
//PrimaryKeys91[2] = dtDisChanReferOld.Columns["PERIOD"];
//PrimaryKeys91[3] = dtDisChanReferOld.Columns["CHAN_NO"];
//PrimaryKeys91[4] = dtDisChanReferOld.Columns["RITEM"];
//PrimaryKeys91[5] = dtDisChanReferOld.Columns["RPERIOD"];
//dtDisChanReferOld.PrimaryKey = PrimaryKeys91;
//DataColumn[] PrimaryKeys92 = new DataColumn[6];
//PrimaryKeys92[0] = dtDisChanRefer.Columns["DIS_NO"];
//PrimaryKeys92[1] = dtDisChanRefer.Columns["ITEM"];
//PrimaryKeys92[2] = dtDisChanRefer.Columns["PERIOD"];
//PrimaryKeys92[3] = dtDisChanRefer.Columns["CHAN_NO"];
//PrimaryKeys92[4] = dtDisChanRefer.Columns["RITEM"];
//PrimaryKeys92[5] = dtDisChanRefer.Columns["RPERIOD"];
//dtDisChanRefer.PrimaryKey = PrimaryKeys92;
#endregion
#region DIS_ITEM_REFER
ALOModel.MaintainDisItemRefer BCO4 = new ALOModel.MaintainDisItemRefer(ConnectionDB);
dtDisItemReferOld = BCO4.QueryDisItemReferFor111(ParameterList1);
dtDisItemRefer = dtDisItemReferOld.Copy();
DataColumn[] PrimaryKeys41 = new DataColumn[5];
PrimaryKeys41[0] = dtDisItemReferOld.Columns["DIS_NO"];
PrimaryKeys41[1] = dtDisItemReferOld.Columns["ITEM"];
PrimaryKeys41[2] = dtDisItemReferOld.Columns["PERIOD"];
PrimaryKeys41[3] = dtDisItemReferOld.Columns["RITEM"];
PrimaryKeys41[4] = dtDisItemReferOld.Columns["RPERIOD"];
dtDisItemReferOld.PrimaryKey = PrimaryKeys41;
DataColumn[] PrimaryKeys42 = new DataColumn[5];
PrimaryKeys42[0] = dtDisItemRefer.Columns["DIS_NO"];
PrimaryKeys42[1] = dtDisItemRefer.Columns["ITEM"];
PrimaryKeys42[2] = dtDisItemRefer.Columns["PERIOD"];
PrimaryKeys42[3] = dtDisItemRefer.Columns["RITEM"];
PrimaryKeys42[4] = dtDisItemRefer.Columns["RPERIOD"];
dtDisItemRefer.PrimaryKey = PrimaryKeys42;
#endregion
#region DIS_TYPE_TMP
ALOModel.MaintainDisTypeTmp BCO5 = new ALOModel.MaintainDisTypeTmp(ConnectionDB);
dtDisTypeTmpOld = BCO5.QueryDisTypeTmp(ParameterList1);
dtDisTypeTmp = dtDisTypeTmpOld.Copy();
DataColumn[] PrimaryKeys51 = new DataColumn[4];
PrimaryKeys51[0] = dtDisTypeTmpOld.Columns["DIS_NO"];
PrimaryKeys51[1] = dtDisTypeTmpOld.Columns["ITEM"];
PrimaryKeys51[2] = dtDisTypeTmpOld.Columns["PERIOD"];
PrimaryKeys51[3] = dtDisTypeTmpOld.Columns["DIS_TYPE"];
dtDisTypeTmpOld.PrimaryKey = PrimaryKeys51;
DataColumn[] PrimaryKeys52 = new DataColumn[4];
PrimaryKeys52[0] = dtDisTypeTmp.Columns["DIS_NO"];
PrimaryKeys52[1] = dtDisTypeTmp.Columns["ITEM"];
PrimaryKeys52[2] = dtDisTypeTmp.Columns["PERIOD"];
PrimaryKeys52[3] = dtDisTypeTmp.Columns["DIS_TYPE"];
dtDisTypeTmp.PrimaryKey = PrimaryKeys52;
#endregion
#region DIS_TYPE_109_TMP
ALOModel.MaintainDisType109Tmp BCO6 = new ALOModel.MaintainDisType109Tmp(ConnectionDB);
dtDisType109TmpOld = BCO6.QueryDisType109Tmp(ParameterList1);
dtDisTypeTmp109 = dtDisType109TmpOld.Copy();
DataColumn[] PrimaryKeys61 = new DataColumn[6];
PrimaryKeys61[0] = dtDisType109TmpOld.Columns["DIS_NO"];
PrimaryKeys61[1] = dtDisType109TmpOld.Columns["ITEM"];
PrimaryKeys61[2] = dtDisType109TmpOld.Columns["PERIOD"];
PrimaryKeys61[3] = dtDisType109TmpOld.Columns["RANK_CODE"];
PrimaryKeys61[4] = dtDisType109TmpOld.Columns["RANK_LEVEL"];
PrimaryKeys61[5] = dtDisType109TmpOld.Columns["PATTERN_NO"];
dtDisType109TmpOld.PrimaryKey = PrimaryKeys61;
DataColumn[] PrimaryKeys62 = new DataColumn[6];
PrimaryKeys62[0] = dtDisTypeTmp109.Columns["DIS_NO"];
PrimaryKeys62[1] = dtDisTypeTmp109.Columns["ITEM"];
PrimaryKeys62[2] = dtDisTypeTmp109.Columns["PERIOD"];
PrimaryKeys62[3] = dtDisTypeTmp109.Columns["RANK_CODE"];
PrimaryKeys62[4] = dtDisTypeTmp109.Columns["RANK_LEVEL"];
PrimaryKeys62[5] = dtDisTypeTmp109.Columns["PATTERN_NO"];
dtDisTypeTmp109.PrimaryKey = PrimaryKeys62;
#endregion
#region DIS_ASSIST
ALOModel.MaintainDisAssist BCO7 = new ALOModel.MaintainDisAssist(ConnectionDB);
dtDisAssistMainOld = BCO7.QueryDisAssistMainWithoutChan(ParameterList1);
dtDisAssistMain = dtDisAssistMainOld.Copy();
DataColumn[] PrimaryKeys71 = new DataColumn[4];
PrimaryKeys71[0] = dtDisAssistMainOld.Columns["DIS_NO"];
PrimaryKeys71[1] = dtDisAssistMainOld.Columns["ITEM"];
PrimaryKeys71[2] = dtDisAssistMainOld.Columns["PERIOD"];
PrimaryKeys71[3] = dtDisAssistMainOld.Columns["ASSIST_CODE"];
dtDisAssistMainOld.PrimaryKey = PrimaryKeys71;
DataColumn[] PrimaryKeys72 = new DataColumn[4];
PrimaryKeys72[0] = dtDisAssistMain.Columns["DIS_NO"];
PrimaryKeys72[1] = dtDisAssistMain.Columns["ITEM"];
PrimaryKeys72[2] = dtDisAssistMain.Columns["PERIOD"];
PrimaryKeys72[3] = dtDisAssistMain.Columns["ASSIST_CODE"];
dtDisAssistMain.PrimaryKey = PrimaryKeys72;
//20090818 added
dtDisAssistDetlAll = BCO7.QueryDisAssistDetlWithoutChan(ParameterList1);
#endregion
#region DIS_REC
ALOModel.MaintainDisTmpRec BCO8 = new ALOModel.MaintainDisTmpRec(ConnectionDB);
ParameterList1.Clear();
ParameterList1.Add(s_ID_DisRec);
dtDisTmpRecOld = BCO8.QueryById(ParameterList1);
dtDisTmpRec = dtDisTmpRecOld.Copy();
DataColumn[] PrimaryKeys81 = new DataColumn[2];
PrimaryKeys81[0] = dtDisTmpRecOld.Columns["ID"];
PrimaryKeys81[1] = dtDisTmpRecOld.Columns["CODE"];
dtDisTmpRecOld.PrimaryKey = PrimaryKeys81;
DataColumn[] PrimaryKeys82 = new DataColumn[2];
PrimaryKeys82[0] = dtDisTmpRec.Columns["ID"];
PrimaryKeys82[1] = dtDisTmpRec.Columns["CODE"];
dtDisTmpRec.PrimaryKey = PrimaryKeys82;
#endregion
#endregion
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
protected void btn_Save_Click(object sender, EventArgs e)
{
#region
try
{
ErrorMsgLabel.Text = "";
ResultMsgLabel.Text = "";
hiddenErrMsg.Value = "";
DateTime ProcessingDateTime = DateTime.Now;
string strItem = SLP_SKU1.Text;
string strPeriod = SLP_ItemPeriod1.Text;
string strDisType = SLP_PARAM1.Text;
string strDisDate = SLP_SLPDate1.Text;
string strStAcceptDate = SLP_SLPDate2.Text;
string strUserId = Session["UID"].ToString();
string strErrMsgTmp = "";
#region
if (!GetItemPeriodDisStateByItemPeriod(strItem, strPeriod, strStAcceptDate, out strErrMsgTmp))
{
ErrorMsgLabel.Text = strErrMsgTmp;
return;
}
//如果Rank類別＝109 且未設定pattern等級設定則不繼續執行
if (strDisType == "109" && (dtDisTypeTmp109 == null || dtDisTypeTmp109.Rows.Count <= 0))
{
ErrorMsgLabel.Text = "無設定等級資料，請確認配本方式或重新設定";
return;
}
SetDisTmpRec(strDisDate, strStAcceptDate, strItem, strPeriod, strDisType, strUserId, ProcessingDateTime);
SetDisMain(strDisDate, strStAcceptDate, strUserId, ProcessingDateTime);
SetDisItem(strItem, strPeriod, strDisType, strUserId, ProcessingDateTime);
SetDisChan(strItem, strPeriod, strStAcceptDate, strDisType, strUserId, ProcessingDateTime);
ALOModel.MaintainDisRecord BCO = new ALOModel.MaintainDisRecord(ConnectionDB);
//當為新增模式時，或編輯模式下改變配本方式
if (CurrentPageMode == PageCurrentMode.Insert || (CurrentPageMode == PageCurrentMode.Edit && s_DIS_TYPE_Original != strDisType))
{
if (strDisType == "101" || strDisType == "103" || strDisType == "104")
{
dtDisItemRefer = BCO.QueryDisItemReferByDisType(dtParam, dtDisItem, strDisType, strItem, strPeriod, vItemReferCount);
currentGvMode = CurrentGridviewMode.View;
gv_ItemRefer.DataSource = dtDisItemRefer;
gv_ItemRefer.DataBind();
hiddenDtDisItemReferCounts.Value = dtDisItemRefer.Rows.Count.ToString();
CalculateReferRateSum();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", string.Format("SwitchControlDisplay('{0}','{1}',1);", Panel_ItemRefer.ClientID, hiddenItemReferDisplayMode.ClientID), true);
}
}
SetDisItemRefer(strUserId, ProcessingDateTime);
#endregion
if (CurrentPageMode == PageCurrentMode.Insert)
{
#region
ALOModel.ALOCommon BCOCommon = new ALOModel.ALOCommon();
System.Data.Common.DbTransaction DBT = BCOCommon.OpenAndGetConnection(ConnectionDB).BeginTransaction();
try
{
string strDisNo = BCO.CreateDisRecordFor131(dtDisTmpRec, dtDisMain, dtDisItem, dtDisChan, dtDisItemRefer, dtDisTypeTmp109, dtDisTypeTmp, strItem, strPeriod, strUserId, DBT);
if (strDisNo != "")
{
ALOModel.MaintainDisTmpRec BCO2 = new ALOModel.MaintainDisTmpRec(ConnectionDB);
BCO2.CreateDisTmpRec(dtDisTmpRec, strDisNo, DBT);
}
DBT.Commit();//交易成功
}
catch (Exception ex)
{
DBT.Rollback();//交易失敗
throw ex;
}
QueryData();
ResultMsgLabel.Text = "新增成功";
#endregion
}
else if (CurrentPageMode == PageCurrentMode.Edit)
{
#region
SetPrimaryKeyForDataTable();
ALOModel.ALOCommon BCOCommon = new ALOModel.ALOCommon();
System.Data.Common.DbTransaction DBT = BCOCommon.OpenAndGetConnection(ConnectionDB).BeginTransaction();
try
{
bool bResult = BCO.UpdateDisRecordFor131(dtDisTmpRec, dtDisTmpRecOld,
dtDisMain, dtDisMainOld, dtDisItem, dtDisItemOld,
dtDisChan, dtDisChanOld, dtDisItemRefer, dtDisItemReferOld,
dtDisTypeTmp109, dtDisType109TmpOld,
dtDisTypeTmp, dtDisTypeTmpOld, null, s_DISNO, strItem, strPeriod, strUserId, strStAcceptDate, DBT);
if (bResult)
{
ALOModel.MaintainDisTmpRec BCO2 = new ALOModel.MaintainDisTmpRec(ConnectionDB);
BCO2.UpdateDisTmpRec(dtDisTmpRec, dtDisTmpRecOld, s_DISNO, DBT);
}
DBT.Commit();//交易成功
}
catch (Exception ex)
{
DBT.Rollback();//交易失敗
throw ex;
}
QueryData();
ResultMsgLabel.Text = "更新成功";
#endregion
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "SwitchControlDisplay", string.Format("SwitchControlDisplay('{0}','{1}',0);", Panel_AddNewItem.ClientID, hiddenDisplayMode.ClientID), true);
SwitchSaveCancelButton(false);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
protected void SmartGridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
#region
try
{
if (dtForMasterAndDetail != null && dtForMasterAndDetail.Rows.Count > 0)
{
ALOModel.MaintainDisTmpRec BCO = new ALOModel.MaintainDisTmpRec(ConnectionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
string strID = "", strCode = "";
strID = ((Label)SmartGridView1.Rows[e.RowIndex].FindControl("lbl_ID")).Text.Trim();
strCode = ((Label)SmartGridView1.Rows[e.RowIndex].FindControl("lbl_CODE")).Text.Trim();
ParameterList.Add(strID);
ParameterList.Add(strCode);
ParameterList.Add(Session["UID"].ToString());
BCO.DeleteForPageTmp(ParameterList, null);
QueryData();
ClearDisItemData();
ResultMsgLabel.Text = "刪除成功";
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
CurrentPageMode = PageCurrentMode.Readonly;
#endregion
}
private void QueryData()
{
#region
DataTable dt = null;
try
{
#region
ALOModel.MaintainDisTmpRec BCO3 = new ALOModel.MaintainDisTmpRec(ConnectionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(PageTimeStamp.Value);
dt = BCO3.QueryByOpCode(ParameterList);
Session[string.Format("{0}_{1}_{2}", strPreFixed, PageTimeStamp.Value,Session["UID"].ToString())] = dt;
#region 設定計算配量所需參數
aryDisNoTemp.Clear();
for (Int32 i = 0; i <= dt.Rows.Count - 1; i++)
{
aryDisNoTemp.Add(dt.Rows[i]["DIS_NO"].ToString().Trim());//存入已設定之DIS_NO
}
if (aryDisNoTemp != null && aryDisNoTemp.Count > 0)
{
aryDisNoTemp.Sort();
for (Int32 i = 0; i <= aryDisNoTemp.Count - 1; i++)
{
strDisNoTemp += string.Format("{0};", aryDisNoTemp[i].ToString());
}
}
hiddenProcessingDisNo.Value = strDisNoTemp;//所有將執行之DIS_NO
hiddenProcessingDisNoCounts.Value = aryDisNoTemp.Count.ToString();//將執行DIS_NO之個數
if (aryDisNoTemp.Count > 0)
{
hiddenFirstDisNo.Value = aryDisNoTemp[0].ToString();//第一筆要執行之DIS_NO
}
else
{
hiddenFirstDisNo.Value = "";
}
#endregion
#endregion
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
dtForMasterAndDetail = dt;
SmartGridView1.DataSource = dt;
SmartGridView1.DataBind();
if (dt == null || (dt != null && dt.Rows.Count <= 0))
{
//ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "ClientScript", "alert('查無資料');", true);
ResultMsgLabel.Text = "查無資料";
CurrentPageMode = PageCurrentMode.Readonly;
}
else
{
//LastPageMode = PageCurrentMode.Query;
CurrentPageMode = PageCurrentMode.Readonly;
}
#endregion
}
