private void Update_GV() { string ConnectionDB = ((DatabaseSettings)ConfigurationSettings.GetConfig("dataConfiguration")).DefaultDatabase; SYSModel.MaintainUserprogauthrel BCO = new SYSModel.MaintainUserprogauthrel(ConnectionDB); #region 取得更新前舊值 #region 使用XML轉回DataSet DataSet Ds = new DataSet(); System.IO.StringReader sr = new System.IO.StringReader(ProgOLDData.InnerHtml); Ds.ReadXml(sr); DataTable Dt = Ds.Tables[0]; #endregion if (Ds.Tables[0].Rows.Count == 0) { throw new Exception("抓取不到舊值,更新失敗!"); } #endregion for (int i = 0; i < GridView1.Rows.Count; i++) { #region 加入更新條件 ParameterList.Clear(); //舊值 ParameterList.Add(Dt.Rows[i]["ID"]); ParameterList.Add(Dt.Rows[i]["CODE"]); ParameterList.Add(Dt.Rows[i]["NAME"]); ParameterList.Add(Dt.Rows[i]["CREATEDATE"]); ParameterList.Add(Dt.Rows[i]["CREATEUID"]); ParameterList.Add(Dt.Rows[i]["UPDATEDATE"]); ParameterList.Add(Dt.Rows[i]["UPDATEUID"]); ParameterList.Add(Dt.Rows[i]["ENABLE"]); ParameterList.Add(Dt.Rows[i]["USERCODE"]); ParameterList.Add(Dt.Rows[i]["SYSTEMCODE"]); ParameterList.Add(Dt.Rows[i]["PROGRAMCODE"]); ParameterList.Add(Dt.Rows[i]["CANCREATE"]); ParameterList.Add(Dt.Rows[i]["CANREAD"]); ParameterList.Add(Dt.Rows[i]["CANUPDATE"]); ParameterList.Add(Dt.Rows[i]["CANDELETE"]); //需要更新值 int enable = 0; int create = 0; int read = 0; int update = 0; int delete = 0; if (((CheckBox)GridView1.Rows[i].FindControl("chk_Enable")).Checked) { enable = 1; } if (((CheckBox)GridView1.Rows[i].FindControl("chk_Create")).Checked) { create = 1; } if (((CheckBox)GridView1.Rows[i].FindControl("chk_Read")).Checked) { read = 1; } if (((CheckBox)GridView1.Rows[i].FindControl("chk_Update")).Checked) { update = 1; } if (((CheckBox)GridView1.Rows[i].FindControl("chk_Delete")).Checked) { delete = 1; } DateTime processtime = DateTime.Now; ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(enable);//enable ParameterList.Add(create);//create ParameterList.Add(read);//read ParameterList.Add(update);//update ParameterList.Add(delete);//delete #endregion int Result = BCO.UpdateProgramList(ParameterList, null); if (Result == 0) { ErrorMsgLabel.Text = "XX"; } else { ErrorMsgLabel.Text = "OK"; } } }
}//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_UserCode = ((WUI.SLP.User)this.FormView1.FindControl("SLP_UserCode")).Text; string v_SystemCode = "VDS2G";//string v_SystemCode = ((TextBox)FormView1.FindControl("TextBoxSystemCode")).Text; string v_ProgramCode = ((WUI.SLP.Program)this.FormView1.FindControl("SLP_ProgramCode")).Text; string v_CanCreate = ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_CanCreate")).Text.Trim(); string v_CanRead = ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_CanRead")).Text.Trim(); string v_CanUpdate = ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_CanUpdate")).Text.Trim(); string v_CanDelete = ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_CanDelete")).Text.Trim(); string v_Enable = "1";// ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_Enable")).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]["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]["USERCODE"]); ParameterList.Add(Dt.Rows[0]["SYSTEMCODE"]); ParameterList.Add(Dt.Rows[0]["PROGRAMCODE"]); ParameterList.Add(Dt.Rows[0]["CANCREATE"]); ParameterList.Add(Dt.Rows[0]["CANREAD"]); ParameterList.Add(Dt.Rows[0]["CANUPDATE"]); ParameterList.Add(Dt.Rows[0]["CANDELETE"]); //需要更新值 ParameterList.Add(v_Name); ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(v_UserCode); ParameterList.Add(v_SystemCode); ParameterList.Add(v_ProgramCode); ParameterList.Add(int.Parse(v_CanCreate)); ParameterList.Add(int.Parse(v_CanRead)); ParameterList.Add(int.Parse(v_CanUpdate)); ParameterList.Add(int.Parse(v_CanDelete)); ParameterList.Add(int.Parse(v_Enable)); #endregion SYSModel.MaintainUserprogauthrel BCO = new SYSModel.MaintainUserprogauthrel(ConnectionDB); UpdateRecord = BCO.UpdateUserprogauthrel(ParameterList, null); if (UpdateRecord == 0) { throw new Exception("更新0筆資料!"); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "SYS162", "<script>alert('更新完成');</script>"); ChangeFormMode(FormViewMode.ReadOnly); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
}//end InsertCancelButton_Click /// <summary> /// 由新增模式,確認新增 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void InsertButton_Click(object sender, EventArgs e) { try { ErrorMsgLabel.Text = ""; int AddRecord = 0; #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_UserCode = ((WUI.SLP.User)this.FormView1.FindControl("SLP_UserCode")).Text; string v_SystemCode = "VDS2G";//((TextBox)FormView1.FindControl("TextBoxSystemCode")).Text; string v_ProgramCode = ((WUI.SLP.Program)this.FormView1.FindControl("SLP_ProgramCode")).Text; string v_CanCreate = ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_CanCreate")).Text.Trim(); string v_CanRead = ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_CanRead")).Text.Trim(); string v_CanUpdate = ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_CanUpdate")).Text.Trim(); string v_CanDelete = ((WUI.SLP.SLP_Boolean)FormView1.FindControl("SLP_CanDelete")).Text.Trim(); //SYSModel.MaintainUser BCO1 = new SYSModel.MaintainUser(ConnectionDB); //ParameterList.Clear(); //ParameterList.Add(v_UserCode); //DataTable Chkuser = BCO1.QueryUserByCode(ParameterList); //if (Chkuser.Rows.Count != 1) //{ // ErrorMsgLabel.Text = "請輸入正確人員代號"; // return; //} SYSModel.MaintainUserprogauthrel Uniq = new SYSModel.MaintainUserprogauthrel(ConnectionDB); ParameterList.Clear(); ParameterList.Add(v_UserCode); ParameterList.Add(v_ProgramCode); DataTable Dup = Uniq.QueryDup(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_UserCode); ParameterList.Add(v_SystemCode); ParameterList.Add(v_ProgramCode); ParameterList.Add(1); ParameterList.Add(v_CanCreate); ParameterList.Add(v_CanRead); ParameterList.Add(v_CanUpdate); ParameterList.Add(v_CanDelete); #endregion SYSModel.MaintainUserprogauthrel BCO = new SYSModel.MaintainUserprogauthrel(ConnectionDB); AddRecord = BCO.CreateUserprogauthrel(ParameterList, null); if (AddRecord == 0) { throw new Exception("新增0筆資料!"); } else { Response.Write("<script>alert('新增完成');location.replace('SYS162.aspx?mode=readonly&ID=" + AddRecord + "');</script>"); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
}//end EditButton_Click #region Gridview1 private void Programbind() { string ConnectionDB = ((DatabaseSettings)ConfigurationSettings.GetConfig("dataConfiguration")).DefaultDatabase; SYSModel.MaintainUserprogauthrel BCO = new SYSModel.MaintainUserprogauthrel(ConnectionDB); ParameterList.Clear(); ParameterList.Add(this.hiddenUSER.Value); DataTable Dt = BCO.QueryProgramList(ParameterList); ProgOLDData.InnerHtml = Dt.DataSet.GetXml(); GridView1.DataSource = Dt; GridView1.PageSize = 10; GridView1.PageIndex = 0; GridView1.DataBind(); }
private void Loaddata(string NewCode) { SYSModel.MaintainUserprogauthrel BCO = new SYSModel.MaintainUserprogauthrel(ConnectionDB); ParameterList.Clear(); ParameterList.Add(NewCode); DataTable Dt = BCO.QueryUserprogauthrelByID(ParameterList); if (Dt != null) { if (Dt.Rows.Count == 0) { ArrayList AL = (ArrayList)Session["SYS16_SortKey" + Request.QueryString["SYS162_PageTimeStamp"]]; string strRemove = "id=" + NewCode; AL.Remove(strRemove); Session["SYS16_SortKey" + Request.QueryString["SYS162_PageTimeStamp"]] = AL; throw new Exception("此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!"); } } }
/// <summary> /// 取得所有Master資料以巡覽 /// </summary> private void GetAllMasterRecordsForBrowse() { #region SYSModel.MaintainUserprogauthrel BCO = new SYSModel.MaintainUserprogauthrel(ConnectionDB); DataTable dtTemp = BCO.QueryUserprogauthrelByALL(); DataView dvForBrowse = dtTemp.DefaultView; dtForBrowse = dvForBrowse.ToTable(); #endregion }
/// <summary> /// 於檢視模式,按下刪除鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void DeleteButton_Click(object sender, EventArgs e) { try { ErrorMsgLabel.Text = ""; int DeleteRecord = 0; #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]["USERCODE"]); ParameterList.Add(Dt.Rows[0]["SYSTEMCODE"]); ParameterList.Add(Dt.Rows[0]["PROGRAMCODE"]); ParameterList.Add(Dt.Rows[0]["CANCREATE"]); ParameterList.Add(Dt.Rows[0]["CANREAD"]); ParameterList.Add(Dt.Rows[0]["CANUPDATE"]); ParameterList.Add(Dt.Rows[0]["CANDELETE"]); //需要更新值 ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); #endregion SYSModel.MaintainUserprogauthrel BCO = new SYSModel.MaintainUserprogauthrel(ConnectionDB); DeleteRecord = BCO.DeleteUserprogauthrel(ParameterList, null); if (DeleteRecord == 0) { throw new Exception("刪除失敗!"); } else { Response.Write("<script>alert('刪除完成');location.replace('SYS161.aspx?Code=SYS16');</script>"); } ChangeFormMode(FormViewMode.ReadOnly); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
/// <summary> /// 繫結資料 /// </summary> /// <param name=VirtualDataID></param> private void databind(FormViewMode fvm) { try { SYSModel.MaintainUserprogauthrel BCO = new SYSModel.MaintainUserprogauthrel(ConnectionDB); ParameterList.Clear(); if (Request["ID"] != null) ParameterList.Add(Request["ID"].ToString()); else ParameterList.Add("0"); dt_Result = BCO.QuerySwitch(SYSModel.MaintainUserprogauthrel.QueryType.ID, ParameterList ); if (dt_Result.Rows.Count > 0) { this.hiddenID.Value = dt_Result.Rows[0]["ID"].ToString(); this.hiddenUSER.Value = dt_Result.Rows[0]["USERCODE"].ToString(); FormView1.DataSource = dt_Result; FormView1.DataBind(); } AuthorityControls(this); //ToolBarStatus switch (fvm) { case FormViewMode.Edit: ToolBarStatus("edit"); break; case FormViewMode.Insert: ToolBarStatus("insert"); break; case FormViewMode.ReadOnly: ToolBarStatus("readonly"); break; } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }//databind
/// <summary> /// 處理權限 /// </summary> private void ProcessAuthority() { try { bool PageCanCreate = false; bool PageCanRead = false; bool PageCanUpdate = false; bool PageCanDelete = false; if (_PageProgramCode != null) //有給PageProgramCode 使用Page { SYSModel.MaintainUserprogauthrel PermissionProcess = new SYSModel.MaintainUserprogauthrel(ConnectionDB); #region 輸入參數 ParameterList.Clear(); //使用者 ParameterList.Add(Session["UID"].ToString()); //功能代碼 ParameterList.Add(_PageProgramCode); #endregion DataTable Dt = PermissionProcess.QueryPermissionByUser(ParameterList); if (Dt.Rows.Count > 0) { PageCanCreate = (Dt.Rows[0]["CanCreate"].ToString() == "1") ? true : false; PageCanRead = (Dt.Rows[0]["CanRead"].ToString() == "1") ? true : false; PageCanUpdate = (Dt.Rows[0]["CanUpdate"].ToString() == "1") ? true : false; PageCanDelete = (Dt.Rows[0]["CanDelete"].ToString() == "1") ? true : false; } } else { PageCanCreate = ((WUI.BaseSecurePage)Page).CanCreate; PageCanRead = ((WUI.BaseSecurePage)Page).CanRead; PageCanUpdate = ((WUI.BaseSecurePage)Page).CanUpdate; PageCanDelete = ((WUI.BaseSecurePage)Page).CanDelete; } //管理員 if (Session["UID"].ToString() == "admin") { PageCanCreate = true; PageCanRead = true; PageCanUpdate = true; PageCanDelete = true; } #region 無新增權限 if (!PageCanCreate) { BtnNewEnable = false; BtnCopyEnable = false; } #endregion #region 無讀取權限 if (!PageCanRead) { BtnFindEnable = false; BtnFindExportEnable = false; BtnRecFirstEnable = false; BtnRecPreEnable = false; BtnRecNextEnable = false; BtnRecLastEnable = false; } #endregion #region 無更新權限 if (!PageCanUpdate) { BtnEditEnable = false; } #endregion #region 無刪除權限 if (!PageCanDelete) { BtnDeleteEnable = false; } #endregion #region 儲存必須獨立判斷 if (PageCanCreate || PageCanUpdate) { //由現在狀況判斷是否要開啟SAVE BtnSaveEnable = BtnSave.Enabled && true; } else { BtnSaveEnable = false; } #endregion } catch (Exception ex) { throw ex; } }
/// <summary> /// 抓取功能號權限 /// </summary> /// <param name="FunctionID">功能號代碼</param> /// <returns>回傳功能號權限資料</returns> private DataTable GetFuncCRUD(string FunctionID) { DataTable ReturnDt = new DataTable(); DataColumn Dc = new DataColumn("CanCreate"); ReturnDt.Columns.Add(Dc); DataColumn Dc1 = new DataColumn("CanRead"); ReturnDt.Columns.Add(Dc1); DataColumn Dc2 = new DataColumn("CanUpdate"); ReturnDt.Columns.Add(Dc2); DataColumn Dc3 = new DataColumn("CanDelete"); ReturnDt.Columns.Add(Dc3); //如果是管理員 if (Session["UID"].ToString() == "admin") { DataRow Dr = ReturnDt.NewRow(); Dr["CanCreate"] = true; Dr["CanRead"] = true; Dr["CanUpdate"] = true; Dr["CanDelete"] = true; ReturnDt.Rows.Add(Dr); } else { SYSModel.MaintainUserprogauthrel PermissionProcess = new SYSModel.MaintainUserprogauthrel(ConnectionDB); #region 輸入變數 ParameterList.Clear(); //使用者 ParameterList.Add(Session["UID"].ToString()); //功能代碼 ParameterList.Add(FunctionID); #endregion DataTable Dt = PermissionProcess.QueryPermissionByUser(ParameterList); if (Dt.Rows.Count == 0) { throw new Exception("找不到" + FunctionID + "的權限!"); } else { DataRow Dr = ReturnDt.NewRow(); Dr["CanCreate"] = (Dt.Rows[0]["CanCreate"].ToString() == "1") ? true : false; Dr["CanRead"] = (Dt.Rows[0]["CanRead"].ToString() == "1") ? true : false; Dr["CanUpdate"] = (Dt.Rows[0]["CanUpdate"].ToString() == "1") ? true : false; Dr["CanDelete"] = (Dt.Rows[0]["CanDelete"].ToString() == "1") ? true : false; ReturnDt.Rows.Add(Dr); } } return ReturnDt; }
/// <summary> /// 設定網頁功能權限 /// </summary> private void SetPageCRUD() { string URLStr = Request.ServerVariables["URL"].ToString(); string[] WebPageName = URLStr.Split('/'); string WebPage = WebPageName[WebPageName.Length - 1]; SYSModel.MaintainUserprogauthrel PermissionProcess = new SYSModel.MaintainUserprogauthrel(ConnectionDB); if (Request.QueryString["Code"] != null) { #region 輸入變數 ParameterList.Clear(); //使用者 ParameterList.Add(Session["UID"].ToString()); //功能代碼 if (Request.QueryString["Code"].ToString().Length < 5) { ParameterList.Add(Request.QueryString["Code"].ToString()); } else { ParameterList.Add(Request.QueryString["Code"].ToString().Substring(0, 5)); } #endregion } else { #region 輸入變數 ParameterList.Clear(); //使用者 ParameterList.Add(Session["UID"].ToString()); //功能代碼 ParameterList.Add(WebPage.ToString().Substring(0, 5)); #endregion } if (isnumeric(WebPage.Substring(3,1))) //如果是程式頁(第4碼為數字) { //如果是管理員 if (Session["UID"].ToString() == __AdminUser) { _CanCreate = true; _CanRead = true; _CanUpdate = true; _CanDelete = true; } else { DataTable Dt = PermissionProcess.QueryPermissionByUser(ParameterList); if (Dt.Rows.Count > 0) { _CanCreate = (Dt.Rows[0]["CanCreate"].ToString() == "1") ? true : false; _CanRead = (Dt.Rows[0]["CanRead"].ToString() == "1") ? true : false; _CanUpdate = (Dt.Rows[0]["CanUpdate"].ToString() == "1") ? true : false; _CanDelete = (Dt.Rows[0]["CanDelete"].ToString() == "1") ? true : false; } } } }
/// <summary> /// 查詢資料庫取得資料 /// </summary> private void databind() { //抓取本頁初次登記的時間 string SessionIDName = "SYS161_" + PageTimeStamp.Value; SYSModel.MaintainUserprogauthrel BCO = new SYSModel.MaintainUserprogauthrel(ConntionDB); ParameterList.Clear(); ParameterList.Add("");//ParameterList.Add(TextBoxCode.Text.Trim()); ParameterList.Add(TextBoxName.Text.Trim()); ParameterList.Add(TextBoxCreateDate.StartDate.Trim()); ParameterList.Add(TextBoxCreateDate.EndDate.Trim()); ParameterList.Add(TextBoxCreateUID.Text.Trim()); ParameterList.Add(TextBoxUpdateDate.StartDate.Trim()); ParameterList.Add(TextBoxUpdateDate.EndDate.Trim()); ParameterList.Add(TextBoxUpdateUID.Text.Trim()); ParameterList.Add(TextBoxUserCode.Text.Trim()); ParameterList.Add(TextBoxProgramCode.Text.Trim()); ParameterList.Add(""); //ParameterList.Add(TextBoxSystemCode.Text.Trim()); ParameterList.Add(SLP_CanCreate.Text); ParameterList.Add(SLP_CanDelete.Text); ParameterList.Add(SLP_CanRead.Text); ParameterList.Add(SLP_CanUpdate.Text); ParameterList.Add("1");//SLP_Enable.Text); ParameterList.Add(TextBoxRowCountLimit.Text.Trim()); DataTable Dt = BCO.QueryRow(ParameterList, CheckBoxLikeSearch.Checked); Session[SessionIDName] = Dt; GridView1.DataSource = Dt; //設定分頁大小 if (TextBoxPagesize.Text == "0") { GridView1.PageSize = 1; } else { GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); } GridView1.PageIndex = 0; GridView1.DataBind(); #region 將Key值存到Session中 ArrayList arl_Key = new ArrayList(); foreach (DataRow drRow in Dt.Rows) { arl_Key.Add("id=" + drRow["ID"].ToString()); } Session["SYS16_SortKey" + this.PageTimeStamp.Value] = arl_Key; #endregion if (Dt.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; } }
/// <summary> /// 存檔 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { switch (this.hid_PageStatus.Value) { case "EDIT": #region 處理修改作業 try { ErrorMsgLabel.Text = ""; if (GridView1.Rows.Count <= 0) { ErrorMsgLabel.Text = "無資料"; return; } else { SYSModel.MaintainUserprogauthrel BCO = new SYSModel.MaintainUserprogauthrel(ConnectionDB); #region 取得更新前舊值 #region 使用XML轉回DataSet DataTable dtDetailOLD = dt_Result; #endregion if (dtDetailOLD.Rows.Count == 0) { throw new Exception("抓取不到舊值,更新失敗!"); } #endregion BCO.UpdateMaster(this.getMasterParameterList(), this.getDetailData(), null, dtDetailOLD); //由檢視模式切換至編輯模式 this.hid_PageStatus.Value = "VIEW"; SetPageStatus(); databind(); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } #endregion break; default: break; } GMToolbar1.GMToolbarStatus = WUI_GMToolbarV.GMToolbarStatusEnum.Other; GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Find, true, "SYS16A.aspx?mode=VIEW&Code=SYS16&USER="******"&ID=" + user_id, null, WUI_GMToolbarV.ClickAction.LinkURL); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Edit, true, string.Empty, this.btnEdit, WUI_GMToolbarV.ClickAction.ButtonClick); EnableSelectAll(); }
}//PrepDefaultValue private void databind() { #region ErrorMsgLabel.Text = ""; //抓取本頁初次登記的時間 SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value); SYSModel.MaintainUserprogauthrel BCO = new SYSModel.MaintainUserprogauthrel(ConnectionDB); ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.SLP_USERCODE.Text, "string", false)); ParameterList.Add(ddl_Module2.SelectedValue); DataTable Dt = BCO.QueryProgramHierarchyByUser(ParameterList); #region 使用XML放置到前端資料 #endregion dt_Result = Dt; //DataRow[] drs = Dt.Select(string.Format("PROGRAMCODE='{0}'", ddl_Module2.SelectedValue)); //if (drs.Length == 0) //{ // DataRow dr = Dt.NewRow(); // dr["SYSTEMCODE"] = "VDS2G"; // dr["PROGRAMCODE"] = ddl_Module2.SelectedValue; // dr["PROGRAMNAME"] = ddl_Module2.SelectedItem.Text; // dr["PARENTCODE"] = ddl_Module2.SelectedValue.Substring(0, 3).ToString(); // dr["USERCODE"] = this.SLP_USERCODE.Text; // dr["ENABLE"] = 1; // dr["CANCREATE"] = 0; // dr["CANREAD"] = 1; // dr["CANUPDATE"] = 0; // dr["CANDELETE"] = 0; // dr["CREATEDATE"] = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); // dr["CREATEUID"] = Session["UID"].ToString(); // dr["UPDATEDATE"] = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); // dr["UPDATEUID"] = Session["UID"].ToString(); // Dt.Rows.InsertAt(dr, 0); //} SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value); Session[SessionIDName] = Dt; GridView1.DataSource = Dt; GridView1.DataBind(); if (Dt == null || (Dt != null && Dt.Rows.Count <= 0)) { ErrorMsgLabel.Text = "查無資料"; } #endregion }
protected void GetALO03A_Authority() { ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(Session["UID"].ToString()); //使用者 ParameterList.Add("ALO03A"); //功能代碼 PIC.VDS2G.COMMON.SYS.MaintainUserprogauthrel PermissionProcess = new PIC.VDS2G.COMMON.SYS.MaintainUserprogauthrel(ConnectionDB); DataTable Dt = PermissionProcess.QueryPermissionByUser(ParameterList); if (Dt.Rows.Count > 0) { CanCalculate = (Dt.Rows[0]["CanCreate"].ToString() == "1" || Dt.Rows[0]["CanUpdate"].ToString() == "1") ? true : false; } btn_Calculate.Visible = CanCalculate; }