}//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訊息丟出顯示 } }