/// <summary> /// 於檢視模式,按下刪除鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void DeleteButton_Click(object sender, EventArgs e) { int DeleteRecord = 0; try { #region 取得畫面元件的值 DateTime processtime = DateTime.Now; #endregion #region 取得刪除前舊值 #region 使用XML轉回DataSet DataSet Ds = new DataSet(); DataTable Dt = dt_Result; #endregion if (Dt.Rows.Count == 0) { throw new Exception("抓取不到舊值,更新失敗!"); } #endregion #region 加入更新條件 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]["ADDRESS1"]); ParameterList.Add(Dt.Rows[0]["ADDRESS2"]); ParameterList.Add(Dt.Rows[0]["PHONE"]); ParameterList.Add(Dt.Rows[0]["FAX"]); ParameterList.Add(Dt.Rows[0]["EMAIL"]); //需要更新值 ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); #endregion SYSModel.MaintainCompanyInfo BCO = new SYSModel.MaintainCompanyInfo(ConnectionDB); DeleteRecord = BCO.DeleteCompanyInfoReturn(ParameterList, null); if (DeleteRecord == 0) { throw new Exception("刪除失敗!"); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "ClientScript", "alert('刪除完成');location.replace('SYS011.aspx?Code=SYS01');", true); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
}//end EditCancelButton_Click /// <summary> /// 編輯模式,按下更新確認鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void EditCommitButton_Click(object sender, EventArgs e) { try { ErrorMsgLabel.Text = ""; int UpdateRecord = 0; #region 取得畫面元件的值 string v_Name = ((TextBox)FormView1.FindControl("TextBoxName")).Text.Trim(); DateTime processtime = DateTime.Now; string v_Address1 = ((TextBox)FormView1.FindControl("TextBoxAddress1")).Text.Trim(); string v_Address2 = ((TextBox)FormView1.FindControl("TextBoxAddress2")).Text.Trim(); string v_Phone = ((TextBox)FormView1.FindControl("TextBoxPhone")).Text.Trim(); string v_Fax = ((TextBox)FormView1.FindControl("TextBoxFax")).Text.Trim(); string v_EMail = ((WUI.SLP.EMailAddress)FormView1.FindControl("TextBoxEMail")).Text.Trim(); #endregion #region 取得更新前舊值 #region 使用XML轉回DataSet DataSet Ds = new DataSet(); DataTable Dt = dt_Result; #endregion if (Dt.Rows.Count == 0) { throw new Exception("抓取不到舊值,更新失敗!"); } #endregion #region 加入更新條件 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]["ADDRESS1"]); ParameterList.Add(Dt.Rows[0]["ADDRESS2"]); ParameterList.Add(Dt.Rows[0]["PHONE"]); ParameterList.Add(Dt.Rows[0]["FAX"]); ParameterList.Add(Dt.Rows[0]["EMAIL"]); //需要更新值 ParameterList.Add(v_Name); ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(v_Address1); ParameterList.Add(v_Address2); ParameterList.Add(v_Phone); ParameterList.Add(v_Fax); ParameterList.Add(v_EMail); #endregion SYSModel.MaintainCompanyInfo BCO = new SYSModel.MaintainCompanyInfo(ConnectionDB); UpdateRecord = BCO.UpdateCompanyInfoReturn(ParameterList, null); if (UpdateRecord == 0) { throw new Exception("更新0筆資料!"); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "SYS012", "<script>alert('更改完成');</script>"); ChangeFormMode(FormViewMode.ReadOnly); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
private void Loaddata(string NewCode) { SYSModel.MaintainCompanyInfo BCO = new SYSModel.MaintainCompanyInfo(ConnectionDB); ParameterList.Clear(); ParameterList.Add(NewCode); DataTable Dt = BCO.QueryCompanyInfoByID(ParameterList); if (Dt != null) { if (Dt.Rows.Count == 0) { ArrayList AL = (ArrayList)Session["SYS01_SortKey" + Request.QueryString["SYS012_PageTimeStamp"]]; string strRemove = "id=" + NewCode; AL.Remove(strRemove); Session["SYS01_SortKey" + Request.QueryString["SYS012_PageTimeStamp"]] = AL; throw new Exception("此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!"); } } }
}//end InsertCancelButton_Click /// <summary> /// 由新增模式,確認新增 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void InsertButton_Click(object sender, EventArgs e) { try { int AddRecord = 0; ErrorMsgLabel.Text = ""; #region 取得畫面元件的值 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_Address1 = ((TextBox)FormView1.FindControl("TextBoxAddress1")).Text.Trim(); string v_Address2 = ((TextBox)FormView1.FindControl("TextBoxAddress2")).Text.Trim(); string v_Phone = ((TextBox)FormView1.FindControl("TextBoxPhone")).Text.Trim(); string v_Fax = ((TextBox)FormView1.FindControl("TextBoxFax")).Text.Trim(); string v_EMail = ((WUI.SLP.EMailAddress)FormView1.FindControl("TextBoxEMail")).Text.Trim(); ParameterList.Clear(); SYSModel.MaintainProgram Uniq = new SYSModel.MaintainProgram(ConnectionDB); ParameterList.Add(v_Code); ParameterList.Add("SYS_COMPANYINFO"); ParameterList.Add("CODE"); ParameterList.Add(""); DataTable Dup = Uniq.QuerySwitch(SYSModel.MaintainProgram.QueryType.Duplicate, ParameterList ); if (Dup.Rows.Count > 0) { if (Dup.Rows[0]["ENABLE"].ToString() == "1") { throw new Exception("資料重覆!"); } } #endregion #region 加入輸入條件 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_Address1); ParameterList.Add(v_Address2); ParameterList.Add(v_Phone); ParameterList.Add(v_Fax); ParameterList.Add(v_EMail); #endregion SYSModel.MaintainCompanyInfo BCO = new SYSModel.MaintainCompanyInfo(ConnectionDB); AddRecord = BCO.CreateCompanyInfo(ParameterList, null); if (AddRecord == 0) { throw new Exception("新增0筆資料!"); } else { Response.Write("<script>alert('新增完成');location.replace('SYS012.aspx?mode=readonly&ID=" + AddRecord + "');</script>"); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
/// <summary> /// 繫結資料 /// </summary> /// <param name=VirtualDataID></param> private void databind(FormViewMode fvm) { try { SYSModel.MaintainCompanyInfo BCO = new SYSModel.MaintainCompanyInfo(ConnectionDB); ParameterList.Clear(); if (Request["ID"] != null) ParameterList.Add(Request["ID"].ToString()); else ParameterList.Add("0"); dt_Result = BCO.QuerySwitch(SYSModel.MaintainCompanyInfo.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 txtname = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxName")); txtname.Visible = false; break; case FormViewMode.Insert: ToolBarStatus("insert"); break; case FormViewMode.ReadOnly: ToolBarStatus("readonly"); TextBox txtname1 = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxName")); txtname1.Visible = false; break; } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }//databind