}//end InsertCancelButton_Click
/// <summary>
/// 由新增模式，確認新增
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void InsertButton_Click(object sender, EventArgs e)
{
int AddRecord = 0;
CGDModel.CGD36_BCO BCO = new CGDModel.CGD36_BCO(ConnectionDB);
System.Data.Common.DbTransaction DBT = BCO.DBT_Begin();
try
{
if (Dtl_Status != "readonly")
{
ErrorMsgLabel.Text = "請先將明細資料做[存檔]或[更新]，再按主檔[更新]!";
}
else
{
string v_Code = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim();
string v_Name = ((TextBox)FormView1.FindControl("TextBoxName")).Text.Trim();
DateTime processtime = DateTime.Now;
string v_Explain = ((TextBox)FormView1.FindControl("TextBoxEXPLAIN")).Text.Trim();
ParameterList.Clear();
ParameterList.Add(v_Code);
DataTable Dup = BCO.QuerySwitch(CGDModel.CGD36_BCO.QueryType.CODE, ParameterList);
if (Dup.Rows.Count > 0)
{
ErrorMsgLabel.Text = "代碼重覆!";
return;
}
ParameterList.Clear();
ParameterList.Add(v_Code);
ParameterList.Add(v_Name);
ParameterList.Add(processtime); //vCreateDate
ParameterList.Add(Session["UID"].ToString()); //vCreateUID
ParameterList.Add(processtime); //vUpdateDate
ParameterList.Add(Session["UID"].ToString()); //vUpdateUID
ParameterList.Add(v_Explain);
AddRecord = BCO.CreateCodeFile(ParameterList, DBT);
if (AddRecord == 0)
{
ErrorMsgLabel.Text = "新增0筆資料!";
return;
}
else
{
DataTable dtData = dt_DetailOLDData;
for (int i = 0; i < dtData.Rows.Count; i++)
{
ParameterList.Clear();
ParameterList.Add(AddRecord); //CODE_MAIN的ID欄位
ParameterList.Add(processtime);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(processtime);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(v_Code);//CODE_MAIN的CODE欄位
ParameterList.Add(dtData.Rows[i]["SCODE"]);
ParameterList.Add(dtData.Rows[i]["EXPLAIN"]);
ParameterList.Add(dtData.Rows[i]["FIX_COLUMN"]);
BCO.CreateCodeFileDTL(ParameterList, DBT);
}
DBT.Commit();
Response.Write("<script>alert('新增完成');location.replace('CGD362.aspx?code=CGD36&mode=readonly&ID=" + AddRecord + "');</script>");
}
}
}
catch (Exception ex)
{
ErrorMsgLabel_Insert.Text = ex.Message;
}
}
//Update GridView2
protected void Update_Dtl(System.Data.Common.DbTransaction DBT, DateTime processtime)
{
try
{
CGDModel.CGD36_BCO BCO = new CGDModel.CGD36_BCO(ConnectionDB);
string strCode = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim();
string strID = ((TextBox)FormView1.FindControl("TextBoxID")).Text.Trim();
DataTable dtData = dt_DetailOLDData;
ParameterList.Clear();
ParameterList.Add(strCode);
ParameterList.Add(DateTime.Now);
ParameterList.Add(Session["UID"].ToString());
BCO.DelCodeFileDTLByCode(ParameterList, DBT);
for (int i = 0; i < dtData.Rows.Count; i++)
{
ParameterList.Clear();
ParameterList.Add(strID); //CODE_MAIN的ID欄位
ParameterList.Add(dtData.Rows[i]["CREATEDATE"]);
ParameterList.Add(dtData.Rows[i]["CREATEUID"]);
ParameterList.Add(processtime);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(strCode);//CODE_MAIN的CODE欄位
ParameterList.Add(dtData.Rows[i]["SCODE"]);
ParameterList.Add(dtData.Rows[i]["EXPLAIN"]);
ParameterList.Add(dtData.Rows[i]["FIX_COLUMN"]);
BCO.CreateCodeFileDTL(ParameterList, DBT);
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;//error訊息丟出顯示
}
}