}//end EditCancelButton_Click
protected void btnDelete_Click(object sender, EventArgs e)
{
CGDModel.CGD36_BCO BCO = new CGDModel.CGD36_BCO(ConnectionDB);
System.Data.Common.DbTransaction DBT = BCO.DBT_Begin();
try
{
string strCode = ((HiddenField)FormView1.FindControl("hidCode")).Value.Trim();
string strCreateDate = ((HiddenField)FormView1.FindControl("hidCreateDate")).Value.Trim();
string strCreateUID = ((HiddenField)FormView1.FindControl("hidCreateUID")).Value.Trim();
string strUpdateDate = ((HiddenField)FormView1.FindControl("hidUpdateDate")).Value.Trim();
string strUpdateUID = ((HiddenField)FormView1.FindControl("hidUpdateUID")).Value.Trim();
ParameterList.Clear();
ParameterList.Add(strCode);
ParameterList.Add(DBPara(strCreateDate, ParaType.Date));
ParameterList.Add(strCreateUID);
ParameterList.Add(DBPara(strUpdateDate, ParaType.Date));
ParameterList.Add(strUpdateUID);
ParameterList.Add(DateTime.Now);
ParameterList.Add(Session["UID"].ToString());
BCO.DEL_MAIN(ParameterList, DBT);
ParameterList.Clear();
ParameterList.Add(strCode);
ParameterList.Add(DateTime.Now);
ParameterList.Add(Session["UID"].ToString());
BCO.DelCodeFileDTLByCode(ParameterList, DBT);
DBT.Commit();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "MSG", "alert('刪除完成');location.href='CGD361.aspx?code=CGD36';", true);
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
}
/// <summary>
/// 編輯模式，按下更新確認鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void EditCommitButton_Click(object sender, EventArgs e)
{
//Trace.Warn("EditCommit");
int UpdateRecord = 0;
try
{
if (Dtl_Status != "readonly")
{
ErrorMsgLabel.Text = "請先將明細資料做[存檔]或[更新]，再按主檔[更新]!";
}
else
{
string v_Name = ((TextBox)FormView1.FindControl("TextBoxName")).Text.Trim();
DateTime processtime = DateTime.Now;
string v_Explain = ((TextBox)FormView1.FindControl("TextBoxEXPLAIN")).Text.Trim();
string v_Enable = "1";// ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_Enable")).Text.Trim();
DataSet Ds = new DataSet();
DataTable Dt = dt_Result;
if (Dt.Rows.Count == 0)
{
ErrorMsgLabel.Text = "抓取不到舊值,更新失敗!";
return;
}
DataTable dtData = dt_DetailOLDData;
for (int i = 0; i < dtData.Rows.Count; i++)
{
//檢查SCODE 是否已存在Dt
DataRow[] ins = dtData.Select(string.Format("SCODE='{0}'", dtData.Rows[i]["SCODE"].ToString()));
if (ins.Length > 1)
{
ErrorMsgLabel.Text = "明細代碼重覆!";
return;
}
}
ParameterList.Clear();
//舊值
ParameterList.Add(Dt.Rows[0]["ID"]);
ParameterList.Add(Dt.Rows[0]["CODE"]);
ParameterList.Add(Dt.Rows[0]["NAME"]);
ParameterList.Add(Dt.Rows[0]["CREATEDATE"]);
ParameterList.Add(Dt.Rows[0]["CREATEUID"]);
ParameterList.Add(Dt.Rows[0]["UPDATEDATE"]);
ParameterList.Add(Dt.Rows[0]["UPDATEUID"]);
ParameterList.Add(Dt.Rows[0]["ENABLE"]);
ParameterList.Add(Dt.Rows[0]["EXPLAIN"]);
ParameterList.Add(v_Name);
ParameterList.Add(processtime);
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add(v_Explain);
ParameterList.Add(v_Enable);
CGDModel.CGD36_BCO BCO = new CGDModel.CGD36_BCO(ConnectionDB);
System.Data.Common.DbTransaction DBT = BCO.DBT_Begin();
//Update CGD_Code_MAIN
UpdateRecord = BCO.UpdateCodeFile(ParameterList, DBT);
//Update CGD_Code_DETL
Update_Dtl(DBT, processtime);
BCO.DBT_End(DBT);
//Panel2.Visible = false;
if (UpdateRecord == 0)
{
ErrorMsgLabel.Text = "更新0筆資料!";
return;
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "CGD362", "<script>alert('更改完成');</script>");
ChangeFormMode(FormViewMode.ReadOnly);
}
}
}
catch (Exception ex)
{
this.ErrorMsgLabel.Text = ex.Message;
if (Dtl_Status == "insert")
{
this.Btn_Insert.Visible = true;
this.Btn_Update.Visible = false;
}
else if (Dtl_Status == "edit")
{
this.Btn_Insert.Visible = false;
this.Btn_Update.Visible = true;
}
}
}
}//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;
}
}
