}//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; } }