/// <summary> /// 抓取第一層的選單 /// </summary> private void getMenu() { DataTable UserInfoDt = (DataTable)Session["UserInfo"]; LabelUserName.Text = Session["UID"].ToString(); LabelOrganizationCode.Text = UserInfoDt.Rows[0]["OrganizationCode"].ToString(); UserNameLabel.Text = UserInfoDt.Rows[0]["Name"].ToString(); SYSModel.MaintainProgram prog = new SYSModel.MaintainProgram(ConnectionDB); #region 抓取公司系統代號 ParameterList.Clear(); ParameterList.Add(ConfigurationManager.AppSettings["CompanyCode"]); #endregion DataTable FirstLevelPrgDt = prog.QueryFirstLevelProgram(ParameterList); foreach (DataRow dRow in FirstLevelPrgDt.Rows) { MenuItem mi = new MenuItem(); mi.ImageUrl = "IMG/vision-2008-004.gif"; string url = Application["AppSite_RootDir"].ToString() + "WUI/FMenu.aspx?mid=" + dRow["Code"].ToString().Trim(); mi.NavigateUrl = "javascript:func_OpneMenu('" + url + "');"; mi.Text = dRow["Name"].ToString().Trim(); mi.ToolTip = dRow["Description"].ToString().Trim(); mi.Value = dRow["Name"].ToString().Trim(); this.Menu1.Items.Add(mi); } MenuItem FirstRootItem = new MenuItem(); FirstRootItem.ImageUrl = "IMG/vision-2008-004.gif"; FirstRootItem.Text = "系統登出"; FirstRootItem.Value = "Exit"; this.Menu1.Items.Add(FirstRootItem); FirstLevelPrgDt = null; }
private void Bind_Module2(string parent) { SYSModel.MaintainProgram BCO = new SYSModel.MaintainProgram(ConnectionDB); ParameterList.Clear(); ParameterList.Add(parent); DataTable Dt = BCO.QueryModule_ST(ParameterList); ddl_Module2.DataSource = Dt; ddl_Module2.DataTextField = "NAME"; ddl_Module2.DataValueField = "CODE"; ddl_Module2.DataBind(); }
private void Bind_Module() { SYSModel.MaintainProgram BCO = new SYSModel.MaintainProgram(ConnectionDB); DataTable Dt = BCO.QueryModule(); ddl_Module.DataSource = Dt; ddl_Module.DataTextField = "NAME"; ddl_Module.DataValueField = "CODE"; ddl_Module.DataBind(); Bind_Module2(ddl_Module.SelectedValue); //取分類 }
}//end InsertCancelButton_Click /// <summary> /// 由新增模式,確認新增 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void InsertButton_Click(object sender, EventArgs e) { int AddRecord = 0; try { #region 取得畫面元件的值 string v_Name = ""; string v_Memo = ""; string v_Code = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim(); if (FormView1.FindControl("TextBoxName") != null) { v_Name = ((TextBox)FormView1.FindControl("TextBoxName")).Text.Trim(); } DateTime processtime = DateTime.Now; if (FormView1.FindControl("TextBoxMemo") != null) { v_Memo = ((TextBox)FormView1.FindControl("TextBoxMemo")).Text.Trim(); } ParameterList.Clear(); SYSModel.MaintainProgram Uniq = new SYSModel.MaintainProgram(ConnectionDB); ParameterList.Add(v_Code); ParameterList.Add("SYS_ROLE"); 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_Memo); #endregion SYSModel.MaintainRole BCO = new SYSModel.MaintainRole(ConnectionDB); AddRecord = BCO.CreateRole(ParameterList, null); if (AddRecord == 0) { throw new Exception("新增0筆資料!"); } else { Response.Write("<script>alert('新增完成');location.replace('SYS032.aspx?mode=readonly&ID=" + AddRecord + "');</script>"); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
public Program() { co_main = new BCO.MaintainProgram(ConntionDB); }
public string UniqueName(string Code, string TableName, string ColumnName, string Category, string OrgText ) { string Name = ""; string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase; if ((TableName != "") && (ColumnName != "")) { if (Code != "") { if (Code == OrgText) { Name = "OK"; } else { MaintainProgram BCO = new MaintainProgram(ConnectionDBStr); ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(Code); ParameterList.Add(TableName); ParameterList.Add(ColumnName); if (ColumnName == "SCODE") { ParameterList.Add(Category); } else { ParameterList.Add(""); } DataTable Dt = BCO.QuerySwitch(MaintainProgram.QueryType.Duplicate, ParameterList ); if (Dt.Rows.Count > 0) { if (Dt.Rows[0]["ENABLE"].ToString() == "1")//刪除時Eanble=0 還是存在 { Name = "資料重覆"; } else { Name = "查無資料"; } } else { Name = "查無資料"; } } } } return Name; }
}//end EditCancelButton_Click /// <summary> /// 編輯模式,按下更新確認鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void EditCommitButton_Click(object sender, EventArgs e) { int UpdateRecord = 0; try { #region 取得畫面元件的值 string v_Name = ((TextBox)FormView1.FindControl("TextBoxName")).Text.Trim(); DateTime processtime = DateTime.Now; string v_SystemCode = ((TextBox)FormView1.FindControl("TextBoxSystemCode")).Text.Trim(); string v_ParentCode = ((WUI.SLP.Program)this.FormView1.FindControl("TextBoxParentCode")).Text; string v_LinkUrl = ((TextBox)FormView1.FindControl("TextBoxLinkURL")).Text.Trim(); string v_DisplayOrder = ((WUI.SLP.SLPQuantity)this.FormView1.FindControl("TextBoxDisplayOrder")).Text; string v_ProgramType = ((WUI.SLP.SLPENVProgramType)this.FormView1.FindControl("TextBoxProgramType")).Text; string v_Description = ((TextBox)FormView1.FindControl("TextBoxDescription")).Text.Trim(); string v_IsVisual = "1"; 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]["ID"]); ParameterList.Add(Dt.Rows[0]["CODE"]); ParameterList.Add(Dt.Rows[0]["NAME"]); ParameterList.Add(Dt.Rows[0]["DESCRIPTION"]); 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]["SYSTEMCODE"]); ParameterList.Add(Dt.Rows[0]["PARENTCODE"]); ParameterList.Add(Dt.Rows[0]["LINKURL"]); ParameterList.Add(Dt.Rows[0]["DISPLAYORDER"]); ParameterList.Add(Dt.Rows[0]["PROGRAMTYPE"]); ParameterList.Add(Dt.Rows[0]["ISVISUAL"]); //需要更新值 ParameterList.Add(v_Name); ParameterList.Add(v_Description); ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(v_SystemCode); ParameterList.Add(v_ParentCode); ParameterList.Add(v_LinkUrl); ParameterList.Add(int.Parse(v_DisplayOrder)); ParameterList.Add(int.Parse(v_ProgramType)); ParameterList.Add(int.Parse(v_IsVisual)); ParameterList.Add(int.Parse(v_Enable)); #endregion SYSModel.MaintainProgram BCO = new SYSModel.MaintainProgram(ConnectionDB); UpdateRecord = BCO.UpdateProgramReturn(ParameterList, null); if (UpdateRecord == 0) { throw new Exception("更新0筆資料!"); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "SYS062", "<script>alert('更改完成');</script>"); ChangeFormMode(FormViewMode.ReadOnly); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
private void Loaddata(string NewCode) { SYSModel.MaintainProgram BCO = new SYSModel.MaintainProgram(ConnectionDB); ParameterList.Clear(); ParameterList.Add(NewCode); DataTable Dt = BCO.QueryProgramByID(ParameterList); if (Dt != null) { if (Dt.Rows.Count == 0) { ArrayList AL = (ArrayList)Session["SYS06_SortKey" + Request.QueryString["SYS062_PageTimeStamp"]]; string strRemove = "id=" + NewCode; AL.Remove(strRemove); Session["SYS06_SortKey" + Request.QueryString["SYS062_PageTimeStamp"]] = AL; throw new Exception("此筆資料已被其他使用者刪除,請點選上一筆/下一筆鈕或回查詢頁重新查詢!"); } } }
}//RaiseCallbackEvent #endregion ICallbackEventHandler 實作成員 private void dataget() { if (_TableName == "") { return; } if (_ColumnName == "") { return; } if (_Code == OrgText) { _Name = "OK"; } else { ParameterList.Clear(); SYSModel.MaintainProgram BCO = new SYSModel.MaintainProgram(ConntionDB); ParameterList.Add(_Code); ParameterList.Add(TableName); ParameterList.Add(ColumnName); if (ColumnName == "SCODE")//PS:請註明原因 { //string Category = ((TextBox)this.Parent.FindControl("TextBoxCode")).Text.Trim(); ParameterList.Add(Category); } else { ParameterList.Add(""); } DataTable Dt = BCO.QuerySwitch(SYSModel.MaintainProgram.QueryType.Duplicate, ParameterList ); if (Dt.Rows.Count > 0) { if (Dt.Rows[0]["ENABLE"].ToString() == "1")//刪除時Eanble=0 還是存在 { _Name = "資料重覆"; } else { _Name = "查無資料"; } } else { _Name = "查無資料"; } } TextBoxName.Text = _Name; }//dataget
public SLPUnique() { co_main = new BCO.MaintainProgram(ConntionDB); }
}//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 = ""; DateTime processtime = DateTime.Now; string v_UserCode = ((WUI.SLP.User)this.FormView1.FindControl("TextBoxUserCode")).Text; string v_RoleCode = ((WUI.SLP.Role)this.FormView1.FindControl("TextBoxRoleCode")).Text; ParameterList.Clear(); SYSModel.MaintainProgram Uniq = new SYSModel.MaintainProgram(ConnectionDB); ParameterList.Add(v_UserCode); ParameterList.Add("SYS_USERROLEREL"); ParameterList.Add("USERCODE"); ParameterList.Add(""); #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]["ROLECODE"]); //需要更新值 ParameterList.Add(v_Name); ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(v_UserCode); ParameterList.Add(v_RoleCode); #endregion SYSModel.MaintainUserRoleRel BCO = new SYSModel.MaintainUserRoleRel(ConnectionDB); UpdateRecord = BCO.UpdateUserRoleRel(ParameterList, null); if (UpdateRecord == 0) { throw new Exception("更新0筆資料!"); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "SYS052", "<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) { ErrorMsgLabel.Text = ""; int AddRecord = 0; try { #region 取得畫面元件的值 DateTime processtime = DateTime.Now; string v_UserCode = ((WUI.SLP.User)this.FormView1.FindControl("TextBoxUserCode")).Text; string v_RoleCode = ((WUI.SLP.Role)this.FormView1.FindControl("TextBoxRoleCode")).Text; //TextBox rolename = ((TextBox)this.FormView1.FindControl("TextBoxRoleCode").FindControl("TextBoxName")); string v_RoleName = ""; 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.MaintainRole BCO2 = new SYSModel.MaintainRole(ConnectionDB); ParameterList.Clear(); ParameterList.Add(v_RoleCode); DataTable Chkrole = BCO2.QueryRoleByCode(ParameterList); if (Chkrole.Rows.Count != 1) { ErrorMsgLabel.Text = "請輸入正確角色代號"; return; } else { v_RoleName = Chkrole.Rows[0]["NAME"].ToString(); } ParameterList.Clear(); SYSModel.MaintainProgram Uniq = new SYSModel.MaintainProgram(ConnectionDB); ParameterList.Add(v_UserCode); ParameterList.Add("SYS_USERROLEREL"); ParameterList.Add("USERCODE"); 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("");//ParameterList.Add(v_Code); ParameterList.Add(v_RoleName);//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_RoleCode); #endregion SYSModel.MaintainUserRoleRel BCO = new SYSModel.MaintainUserRoleRel(ConnectionDB); AddRecord = BCO.CreateUserRoleRel(ParameterList, null); if (AddRecord == 0) { throw new Exception("新增0筆資料!"); } else { Response.Write("<script>alert('新增完成');location.replace('SYS052.aspx?mode=readonly&ID=" + AddRecord + "');</script>"); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
/// <summary> /// 查詢資料庫取得資料 /// </summary> private void databind() { //抓取本頁初次登記的時間 string SessionIDName = "SYS061_" + PageTimeStamp.Value; SYSModel.MaintainProgram BCO = new SYSModel.MaintainProgram(ConntionDB); ParameterList.Clear(); 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(TextBoxDescription.Text.Trim()); ParameterList.Add(TextBoxSystemCode.Text.Trim()); ParameterList.Add(TextBoxParentCode.Text.Trim()); ParameterList.Add(TextBoxLinkUrl.Text.Trim()); ParameterList.Add(((DropDownList)TextBoxDisplayOrder.FindControl("D1")).SelectedValue);//operator ParameterList.Add(TextBoxDisplayOrder.Text.Trim()); ParameterList.Add(((DropDownList)SLP_ProgramType.FindControl("D1")).SelectedValue); ParameterList.Add("1");// (SLP_IsVisual.Text.Trim()); ParameterList.Add("1");//SLP_Enable.Text.Trim()); 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["SYS06_SortKey" + this.PageTimeStamp.Value] = arl_Key; #endregion if (Dt.Rows.Count == 0) { this.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; try { #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_Model = ((TextBox)FormView1.FindControl("TextBoxModel")).Text.Trim(); string v_Description = ((TextBox)FormView1.FindControl("TextBoxDescription")).Text.Trim(); string v_Weburl = ((TextBox)FormView1.FindControl("TextBoxWebURL")).Text.Trim(); string v_Mstid = ((TextBox)FormView1.FindControl("TextBoxMstIDSerialNext")).Text.Trim(); ParameterList.Clear(); SYSModel.MaintainProgram Uniq = new SYSModel.MaintainProgram(ConnectionDB); ParameterList.Add(v_Code); ParameterList.Add("SYS_BusMasterMeta"); 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_Model); ParameterList.Add(v_Description); ParameterList.Add(v_Weburl); if (v_Mstid != "") { ParameterList.Add(Decimal.Parse(v_Mstid)); } else { ParameterList.Add(0); } #endregion SYSModel.MaintainBusMasterMeta BCO = new SYSModel.MaintainBusMasterMeta(ConnectionDB); AddRecord = BCO.CreateBusMasterMeta(ParameterList, null); if (AddRecord == 0) { throw new Exception("新增0筆資料!"); } else { Response.Write("<script>alert('新增完成');location.replace('SYS102.aspx?mode=readonly&ID=" + AddRecord + "');</script>"); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
public string ProgramName(string Code) { string Name = ""; string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase; MaintainProgram co_main = new MaintainProgram(ConnectionDBStr); if (Code.Trim() != "") { ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(Code); DataTable Dt = co_main.QueryForSLP(ParameterList); if (Dt.Rows.Count > 0) { Name = Dt.Rows[0]["Name"].ToString().Trim(); } else { Name = "查無資料"; } } return Name; }
/// <summary> /// 繫結資料 /// </summary> /// <param name=VirtualDataID></param> private void databind(FormViewMode fvm) { try { SYSModel.MaintainProgram BCO = new SYSModel.MaintainProgram(ConnectionDB); ParameterList.Clear(); if (Request["ID"] != null) ParameterList.Add(Request["ID"].ToString()); else ParameterList.Add("0"); dt_Result = BCO.QuerySwitch(SYSModel.MaintainProgram.QueryType.ID, ParameterList ); if (dt_Result.Rows.Count > 0) { this.hiddenID.Value = dt_Result.Rows[0]["ID"].ToString(); FormView1.DataSource = dt_Result; FormView1.DataBind(); } AuthorityControls(this); //ToolBarStatus switch (fvm) { case FormViewMode.Edit: //修改All換為空值 DropDownList D2 = ((DropDownList)this.FormView1.FindControl("TextBoxProgramType").FindControl("D1")); D2.Items.RemoveAt(0); TextBox edit_txtname = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxName")); edit_txtname.Visible = false; ToolBarStatus("edit"); break; case FormViewMode.Insert: GMToolbar1.GMToolbarStatus = WUI_GMToolbarV.GMToolbarStatusEnum.NewEdit; ToolBarStatus("insert"); break; case FormViewMode.ReadOnly: //修改All換為空值 DropDownList D3 = ((DropDownList)this.FormView1.FindControl("TextBoxProgramType").FindControl("D1")); D3.Items[0].Text = ""; TextBox txtname = ((TextBox)this.FormView1.FindControl("TextBoxCode").FindControl("TextBoxName")); txtname.Visible = false; ToolBarStatus("readonly"); break; } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }//databind
/// <summary> /// 使用者登入所需作業 /// </summary> /// <param name="UserName">使用者名稱</param> public void UserLogin(string UserName) { //記錄使用者ID Session["UID"] = UserName; //統計人數 #region 傳入使用者ID ParameterList.Clear(); ParameterList.Add(UserName); #endregion //載入使用者資訊 SYSModel.MaintainUser user = new SYSModel.MaintainUser(ConnectionDB); Session["UserInfo"] = user.QueryUserByCode(ParameterList); //載入使用者功能表單 SYSModel.MaintainProgram prog = new SYSModel.MaintainProgram(ConnectionDB); DataTable Dt = prog.QueryAllProgramForUser(ParameterList); SYSModel.MaintainProgauthrel progth = new SYSModel.MaintainProgauthrel(ConnectionDB); DataTable Dt2 = progth.QueryCustProgramForUser(ParameterList); //如果為admin if (ParameterList[0].ToString() == __AdminUser) { for (int i = 0; i < Dt.Rows.Count; i++) { Dt.Rows[i]["Status"] = 1; } } Session["UserProgramStatus"] = Dt; Session["Cust_UserProgramStatus"] = Dt2; }
}//end InsertCancelButton_Click /// <summary> /// 由新增模式,確認新增 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void InsertButton_Click(object sender, EventArgs e) { int AddRecord = 0; try { #region 取得畫面元件的值 string v_Code = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim(); string v_Name = ((TextBox)FormView1.FindControl("TextBoxName")).Text.Trim(); string v_Description = ((TextBox)FormView1.FindControl("TextBoxDescription")).Text.Trim(); DateTime processtime = DateTime.Now; string v_SystemCode = ((TextBox)FormView1.FindControl("TextBoxSystemCode")).Text.Trim(); string v_ParentCode = ((WUI.SLP.Program)this.FormView1.FindControl("TextBoxParentCode")).Text; string v_LinkUrl = ((TextBox)FormView1.FindControl("TextBoxLinkURL")).Text.Trim(); string v_DisplayOrder = ((WUI.SLP.SLPQuantity)this.FormView1.FindControl("TextBoxDisplayOrder")).Text; string v_ProgramType = ((WUI.SLP.SLPENVProgramType)this.FormView1.FindControl("TextBoxProgramType")).Text; ParameterList.Clear(); SYSModel.MaintainProgram Uniq = new SYSModel.MaintainProgram(ConnectionDB); ParameterList.Add(v_Code); ParameterList.Add("SYS_PROGRAM"); 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(v_Description); ParameterList.Add(processtime); //vCreateDate ParameterList.Add(Session["UID"].ToString()); //vCreateUID ParameterList.Add(processtime); //vUpdateDate ParameterList.Add(Session["UID"].ToString()); //vUpdateUID ParameterList.Add(v_SystemCode); ParameterList.Add(v_ParentCode); ParameterList.Add(v_LinkUrl); if (v_DisplayOrder != "") { ParameterList.Add(int.Parse(v_DisplayOrder));} else { ParameterList.Add(0);} if (v_ProgramType != "") { ParameterList.Add(int.Parse(v_ProgramType));} else { ParameterList.Add(0);} #endregion SYSModel.MaintainProgram BCO = new SYSModel.MaintainProgram(ConnectionDB); AddRecord = BCO.CreateProgram(ParameterList, null); if (AddRecord == 0) { throw new Exception("新增0筆資料!"); } else { Response.Write("<script>alert('新增完成');location.replace('SYS062.aspx?mode=readonly&ID=" + AddRecord + "');</script>"); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
}//Initiziatoin_Component private void dataget() { ParameterList.Clear(); SYSModel.MaintainProgram BCO = new SYSModel.MaintainProgram(ConntionDB); ParameterList.Add(_Code); //DataTable Dt = BCO.QuerySwitch(SYSModel.MaintainProgram.QueryType.CODE, // ParameterList // ); DataTable Dt = co_main.QueryForSLP(ParameterList); if (Dt.Rows.Count > 0) { _Name = Dt.Rows[0]["Name"].ToString().Trim(); } else { _Name = "查無資料"; } HiddenField1.Value = _Name; TextBoxName.Text = _Name; }//dataget
/// <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]["DESCRIPTION"]); 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]["SYSTEMCODE"]); ParameterList.Add(Dt.Rows[0]["PARENTCODE"]); ParameterList.Add(Dt.Rows[0]["LINKURL"]); ParameterList.Add(Dt.Rows[0]["DISPLAYORDER"]); ParameterList.Add(Dt.Rows[0]["PROGRAMTYPE"]); ParameterList.Add(Dt.Rows[0]["ISVISUAL"]); //需要更新值 ParameterList.Add(processtime); ParameterList.Add(Session["UID"].ToString()); #endregion SYSModel.MaintainProgram BCO = new SYSModel.MaintainProgram(ConnectionDB); DeleteRecord = BCO.DeleteProgramReturn(ParameterList, null); if (DeleteRecord == 0) { throw new Exception("刪除失敗!"); } else { Response.Write("<script>alert('刪除完成');location.replace('SYS061.aspx?Code=SYS06');</script>"); } } 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 { 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_Organizationcode = ((WUI.SLP.Organization)FormView1.FindControl("TextBoxOrganizationCode")).Text.Trim(); string v_Password = ((TextBox)FormView1.FindControl("TextBoxPassword")).Text.Trim(); string v_Memo = ((TextBox)FormView1.FindControl("TextBoxMemo")).Text.Trim(); if (v_Password.Length < 8) throw new Exception("密碼長度不足8碼!"); //密碼加密 SYSModel.CryptographyHelper Cry = new SYSModel.CryptographyHelper(); string CryPassword = Cry.Encrypt(v_Password); ParameterList.Clear(); SYSModel.MaintainProgram Uniq = new SYSModel.MaintainProgram(ConnectionDB); ParameterList.Add(v_Code); ParameterList.Add("SYS_USER"); 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_Organizationcode); ParameterList.Add(CryPassword); ParameterList.Add(v_Memo); #endregion SYSModel.MaintainUser BCO = new SYSModel.MaintainUser(ConnectionDB); AddRecord = BCO.CreateUser(ParameterList, null); if (AddRecord == 0) { throw new Exception("新增0筆資料!"); } else { LogHelper LOG = new LogHelper(ConnectionDB); ParameterList.Clear(); ParameterList.Add("SYS04人員");//0 ParameterList.Add(Session["UID"].ToString());//1 ParameterList.Add("I");//2 ParameterList.Add(v_Code);//3 ParameterList.Add(Request.ServerVariables["Server_Name"]);//4 LOG.AddSafeLog(ParameterList); Response.Write("<script>alert('新增完成');location.replace('SYS042.aspx?mode=readonly&ID=" + AddRecord + "');</script>"); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }