private void Loaddata(string NewCode) { CGDModel.CGD36_BCO BCO = new CGDModel.CGD36_BCO(ConnectionDB); ParameterList.Clear(); ParameterList.Add(NewCode); DataTable Dt = BCO.QuerySwitch(CGDModel.CGD36_BCO.QueryType.ID, ParameterList); if (Dt != null) { if (Dt.Rows.Count == 0) { ArrayList AL = (ArrayList)Session["CGD36_SortKey" + Request.QueryString["CGD362_PageTimeStamp"]]; string strRemove = "id=" + NewCode; AL.Remove(strRemove); Session["CGD36_SortKey" + Request.QueryString["CGD362_PageTimeStamp"]] = AL; ErrorMsgLabel.Text = "此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!"; } } }
}//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; } }
}//databind /// <summary> /// 繫結資料 MST /// </summary> /// <param name=VirtualDataID></param> private void databind_Mst(FormViewMode fvm) { try { CGDModel.CGD36_BCO BCO = new CGDModel.CGD36_BCO(ConnectionDB); ParameterList.Clear(); if (Request["ID"] != null) ParameterList.Add(Request["ID"].ToString()); else ParameterList.Add("0"); dt_Result = BCO.QuerySwitch(CGDModel.CGD36_BCO.QueryType.ID, ParameterList); if (dt_Result.Rows.Count > 0) { this.hiddenID.Value = dt_Result.Rows[0]["ID"].ToString(); FormView1.DataSource = dt_Result; FormView1.DataBind(); if (dt_Result.Rows[0]["ENABLE"].ToString() == "0") { ((Button)FormView1.FindControl("EditButton")).Visible = false; ((Button)FormView1.FindControl("DeleteButton")).Visible = false; } } AuthorityControls(this); //ToolBarStatus switch (fvm) { case FormViewMode.Edit: ToolBarStatus("edit"); TextBox txtcode = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxCode")); TextBox txtname = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxName")); txtname.Visible = false; txtcode.Width = Unit.Parse("18"); break; case FormViewMode.Insert: ToolBarStatus("insert"); TextBox txtcode2 = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxCode")); txtcode2.Width = Unit.Parse("18"); break; case FormViewMode.ReadOnly: ToolBarStatus("readonly"); TextBox txtcode1 = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxCode")); TextBox txtname1 = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxName")); txtname1.Visible = false; txtcode1.Width = Unit.Parse("18"); break; } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }//databind_Mst