}//databind_Dtl
/// <summary>
/// 繫結資料 DTL2
/// </summary>
private void Load_TempDetail2()
{
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConnectionDB);
ParameterList.Clear();
string strCategory = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim();
ParameterList.Add(strCategory);
ParameterList.Add(DBNull.Value);
ParameterList.Add(DBNull.Value);
DataTable Dt = BCO.QueryTHRID(ParameterList);
dt_TempDetail2 = Dt;//放入暫存檔
lblTitle.Text = "明細清單檔";
lblTab3Msg.Text = "尚未選擇明細代碼";
GridView3.DataSource = null;
GridView3.DataBind();
ButtonNewLine2.Visible = false;
PanelDetail2.Visible = false;
txtDetail2Code.Text = "";
txtDetail2Explain.Text = "";
upTab3Title.Update();
upTab3Detail.Update();
}
/// <summary>
/// 清單插入鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Btn_Detail2Insert_Click(object sender, EventArgs e)
{
try
{
if (dt_TempDetail2.Rows.Count == 0)
{
//從DB讀取一空table回來
SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConnectionDB);
ParameterList.Add("X");
ParameterList.Add("X");
ParameterList.Add("X");
dt_TempDetail2 = BCO.QueryTHRID(ParameterList);
}
int tempID = 0;
DataView tempDT = new DataView();
tempDT.Table = dt_TempDetail2.Copy();
tempDT.Sort = "ID ASC";
if (dt_TempDetail2.Rows.Count != 0)
{
tempID = Convert.ToInt32(tempDT[dt_TempDetail2.Rows.Count - 1]["ID"].ToString());
}
//ID和PID暫自訂, 真正寫入CO時會重取
//LineItem畫面元件內容
string strCategory = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim();
int iPID = int.Parse(hdfSCODE_ID.Value);
string strScode = hdfSCODE.Value;
string strCode = this.txtDetail2Code.Text.Trim();
string strExplain = this.txtDetail2Explain.Text.Trim();
int iID = tempID + 1;
//檢查SCODE 是否已存在Dt
DataRow[] FindRows = dt_TempDetail2.Select(string.Format("CODE='{0}' AND SCODE='{1}'", strCode, strScode));
if (FindRows.Length <= 0) //1:已存在Dt 0:不存在Dt
{
DataRow dRow = dt_TempDetail2.NewRow();
dRow["ID"] = iID;
dRow["PID"] = iPID;
dRow["CREATEDATE"] = DateTime.Now;
dRow["CREATEUID"] = Session["UID"].ToString();
dRow["UPDATEDATE"] = DateTime.Now;
dRow["UPDATEUID"] = Session["UID"].ToString();
dRow["CATEGORY"] = strCategory;
dRow["SCODE"] = strScode;
dRow["CODE"] = strCode;
dRow["EXPLAIN"] = strExplain;
dt_TempDetail2.Rows.Add(dRow);
this.txtDetail2Code.Text = "";
this.txtDetail2Explain.Text = "";
this.PanelDetail2.Visible = false;
BindTempTable_Dtl2(strScode);
this.ButtonNewLine2.Visible = true;
}
else
{
lblTab3Msg.Text = "清單代碼重覆!";
}
}
catch (Exception ex)
{
lblTab3Msg.Text = ex.Message;
}
finally { }
}
