/// <summary>
/// 取得輔助項目主檔與明細檔
/// </summary>
private void GetAssistMainAndDetl()
{
#region
try
{
#region
DataTable dtMain, dtDetl;
ArrayList ParameterList = new ArrayList();//20091106
ParameterList.Clear();
ParameterList.Add(Request.QueryString["DIS_NO"]);
ParameterList.Add(Request.QueryString["ITEM"]);
ParameterList.Add(Request.QueryString["PERIOD"]);
ParameterList.Add(GetChanNo_AssistSetting());
ALOModel.MaintainDisRecord BCO = new ALOModel.MaintainDisRecord(ConnectionDB);
BCO.QueryDisAssistInfoByDisNo(ParameterList, out dtMain, out dtDetl);
string[,] strAryAssistCode = new string[,] { { "01", "chk11" ,"","","","","","","","","","","",""},
{ "02", "chk21" ,"","","","","","","","","","","",""},
{ "03", "chk31" ,"rbtn311","rbtn312","SLP_SLPNumber1","","","","OP_VALUE_3W","OP_VALUE_3Y","OP_VALUE_3X","OP_VALUE_3Z","hiddenOPValueStatus3","" },
{ "04", "chk41" ,"","","","","","","OP_VALUE_4W","OP_VALUE_4Y","OP_VALUE_4X","OP_VALUE_4Z","hiddenOPValueStatus4","" },
{ "05", "chk51" ,"rbtn511","rbtn512","","rbtn521","rbtn522","SLP_SLPNumber2","OP_VALUE_5W","OP_VALUE_5Y","OP_VALUE_5X","OP_VALUE_5Z" ,"hiddenOPValueStatus5",""},
{ "06", "chk61" ,"","","SLP_SLPNumber3","","","","OP_VALUE_6W","OP_VALUE_6Y","OP_VALUE_6X","OP_VALUE_6Z","hiddenOPValueStatus6","" },
{ "07", "chk71" ,"","","SLP_SLPNumber4","rbtn721","rbtn722","SLP_SLPNumber5","OP_VALUE_7W","OP_VALUE_7Y","OP_VALUE_7X","OP_VALUE_7Z","hiddenOPValueStatus7","" },
{ "08", "chk81" ,"","","","","","","OP_VALUE_8W","OP_VALUE_8Y","OP_VALUE_8X","OP_VALUE_8Z","hiddenOPValueStatus8",""} };
Int32 index_OPERATOR1, index_OPERATOR2, index_OP_VALUE1, index_OP_VALUE2, index_CHANGE_TYPE, index_CHANGE_RATE;
if (dtMain != null && dtMain.Rows.Count > 0)
{
for (Int32 k = 0; k <= strAryAssistCode.GetUpperBound(0); k++)
{
((CheckBox)this.TabContainer1.Tabs[1].FindControl(strAryAssistCode[k, 1])).Checked = false;
}
for (Int32 i = 0; i <= dtMain.Rows.Count - 1; i++)
{
for (Int32 k = 0; k <= strAryAssistCode.GetUpperBound(0); k++)
{
//default index
index_OPERATOR1 = 2;//RadioButton
index_OP_VALUE1 = 4;//SLP_Number
index_OPERATOR2 = 5;//RadioButton
index_OP_VALUE2 = 7;//SLP_Number
index_CHANGE_TYPE = 8;//RadioButton
index_CHANGE_RATE = 10;//SLP_Number
if (dtMain.Rows[i]["ASSIST_CODE"].ToString() == strAryAssistCode[k, 0])
{
((CheckBox)this.TabContainer1.Tabs[1].FindControl(strAryAssistCode[k, 1])).Checked = true;
#region
if (dtMain.Rows[i]["OPERATOR1"].ToString().Trim() == "1")// 大於等於(及)
{
index_OPERATOR1 = 2;
}
else if (dtMain.Rows[i]["OPERATOR1"].ToString().Trim() == "2")// 小於等於(或)
{
index_OPERATOR1 = 3;
}
else
{
index_OPERATOR1 = 13;//指定到空白控制項
}
if (dtMain.Rows[i]["OPERATOR2"].ToString().Trim() == "1")// 大於等於(及)
{
index_OPERATOR2 = 5;
}
else if (dtMain.Rows[i]["OPERATOR2"].ToString().Trim() == "2")// 小於等於(或)
{
index_OPERATOR2 = 6;
}
else
{
index_OPERATOR2 = 13;//指定到空白控制項
}
if (dtMain.Rows[i]["CHANGE_TYPE"].ToString().Trim() == "0")// 比例
{
index_CHANGE_TYPE = 8;
if (strAryAssistCode[k, 11] != "")
((Button)this.TabContainer1.Tabs[1].FindControl(strAryAssistCode[k, 11])).Enabled = false;
if (strAryAssistCode[k, 12] != "")
((System.Web.UI.HtmlControls.HtmlInputHidden)this.TabContainer1.Tabs[1].FindControl(strAryAssistCode[k, 12])).Value = "0";
}
else if (dtMain.Rows[i]["CHANGE_TYPE"].ToString().Trim() == "1")// 數量
{
index_CHANGE_TYPE = 9;
if (strAryAssistCode[k, 10] != "")
((WUI.SLP.SLPNumber)this.TabContainer1.Tabs[1].FindControl(strAryAssistCode[k, 10])).ReadOnly = true;
if (strAryAssistCode[k, 11] != "")
((Button)this.TabContainer1.Tabs[1].FindControl(strAryAssistCode[k, 11])).Enabled = true;
if (strAryAssistCode[k, 12] != "")
((System.Web.UI.HtmlControls.HtmlInputHidden)this.TabContainer1.Tabs[1].FindControl(strAryAssistCode[k, 12])).Value = "1";
}
else
{
index_CHANGE_TYPE = 13;//指定到空白控制項
}
#endregion
if (strAryAssistCode[k, index_OPERATOR1] != "")
((RadioButton)this.TabContainer1.Tabs[1].FindControl(strAryAssistCode[k, index_OPERATOR1])).Checked = true;
if (strAryAssistCode[k, index_OP_VALUE1] != "")
((WUI.SLP.SLPNumber)this.TabContainer1.Tabs[1].FindControl(strAryAssistCode[k, index_OP_VALUE1])).Text = dtMain.Rows[i]["OP_VALUE1"].ToString().Trim();
if (strAryAssistCode[k, index_OPERATOR2] != "")
((RadioButton)this.TabContainer1.Tabs[1].FindControl(strAryAssistCode[k, index_OPERATOR2])).Checked = true;
if (strAryAssistCode[k, index_OP_VALUE2] != "")
((WUI.SLP.SLPNumber)this.TabContainer1.Tabs[1].FindControl(strAryAssistCode[k, index_OP_VALUE2])).Text = dtMain.Rows[i]["OP_VALUE2"].ToString().Trim();
if (strAryAssistCode[k, index_CHANGE_TYPE] != "")
((RadioButton)this.TabContainer1.Tabs[1].FindControl(strAryAssistCode[k, index_CHANGE_TYPE])).Checked = true;
if (strAryAssistCode[k, index_CHANGE_RATE] != "")
((WUI.SLP.SLPNumber)this.TabContainer1.Tabs[1].FindControl(strAryAssistCode[k, index_CHANGE_RATE])).Text = dtMain.Rows[i]["CHANGE_RATE"].ToString().Trim();
break;
}
}
}
}
if (dtDetl != null && dtDetl.Rows.Count > 0)
{
dtDisAssistDetlAll = dtDetl.Copy();
}
#endregion
#region
ALOModel.MaintainDisAssist BCO2 = new ALOModel.MaintainDisAssist(ConnectionDB);
ParameterList.Clear();
ParameterList.Add(Request.QueryString["DIS_NO"]);
ParameterList.Add(Request.QueryString["ITEM"]);
ParameterList.Add(Request.QueryString["PERIOD"]);
ParameterList.Add(null);
dtDisAssistMainALO131 = BCO2.QueryDisAssistMain(ParameterList);
#endregion
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
