/// <summary> /// get table record /// <summary> /// <param name=userid>userid</param> /// <param name=privilegename>privilegename</param> /// <param name=out emsg>return error message</param> ///<returns>get a record detail of sysuserprivilege</returns> public modSysUserPrivilege GetItem(string userid, string privilegename, out string emsg) { try { //Execute a query to read the categories string sql = string.Format("select user_id,privilege_name,privilege_value,update_user,update_time from sys_user_privilege where user_id='{0}' and privilege_name='{1}' order by user_id,privilege_name", userid, privilegename); using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql)) { if (rdr.Read()) { modSysUserPrivilege model = new modSysUserPrivilege(); model.UserId = dalUtility.ConvertToString(rdr["user_id"]); model.PrivilegeName = dalUtility.ConvertToString(rdr["privilege_name"]); model.PrivilegeValue = dalUtility.ConvertToString(rdr["privilege_value"]); model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]); model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]); emsg = null; return(model); } else { emsg = "Error on read data"; return(null); } } } catch (Exception ex) { emsg = dalUtility.ErrorMessage(ex.Message); return(null); } }
/// <summary> /// get all sysuserprivilege /// <summary> /// <param name=userid>userid</param> /// <param name=out emsg>return error message</param> ///<returns>details of all sysuserprivilege</returns> public BindingCollection <modSysUserPrivilege> GetIList(string userid, out string emsg) { try { BindingCollection <modSysUserPrivilege> modellist = new BindingCollection <modSysUserPrivilege>(); //Execute a query to read the categories string sql = string.Format("select user_id,privilege_name,privilege_value,update_user,update_time from sys_user_privilege where user_id='{0}' order by user_id,privilege_name", userid); using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql)) { while (rdr.Read()) { modSysUserPrivilege model = new modSysUserPrivilege(); model.UserId = dalUtility.ConvertToString(rdr["user_id"]); model.PrivilegeName = dalUtility.ConvertToString(rdr["privilege_name"]); model.PrivilegeValue = dalUtility.ConvertToString(rdr["privilege_value"]); model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]); model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]); modellist.Add(model); } } emsg = null; return(modellist); } catch (Exception ex) { emsg = dalUtility.ErrorMessage(ex.Message); return(null); } }
private void btnSave_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; BindingCollection <modSysUserPrivilege> list = new BindingCollection <modSysUserPrivilege>(); modSysUserPrivilege mod = new modSysUserPrivilege(); mod.UserId = txtUserId.Text.Trim(); mod.UpdateUser = Util.UserId; mod.PrivilegeName = "CUST_ACCESS_OPTION"; if (rbOwnerOnly.Checked) { mod.PrivilegeValue = "1"; } else if (rbAll.Checked) { mod.PrivilegeValue = "3"; } else { mod.PrivilegeValue = "0"; } list.Add(mod); //mod = new modSysUserPrivilege(); //mod.UserId = txtUserId.Text.Trim(); //mod.UpdateUser = Util.UserId; //mod.PrivilegeName = "UPLOAD_ITEMNO"; //mod.PrivilegeValue = chkUpload.Checked ? "1" : "0"; //list.Add(mod); bool ret = _dal.Save(txtUserId.Text, list, out Util.emsg); if (ret) { this.Dispose(); } else { MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } catch (Exception ex) { MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { this.Cursor = Cursors.Default; } }
private void CRM_DATA_CALENDAR_Load(object sender, EventArgs e) { FillControl.FillCustomerScoreRule(lstActionCode, string.Empty); txtYear.Text = DateTime.Today.Year.ToString(); cboMonth.Text = DateTime.Today.Month.ToString(); txtSalesMan.Text = Util.UserName; dalSysUserPrivilege bllpri = new dalSysUserPrivilege(); modSysUserPrivilege modpri = bllpri.GetItem(Util.UserId, "CUST_ACCESS_OPTION", out Util.emsg); if (modpri != null && modpri.PrivilegeValue == "3") { btnSalesMan.Enabled = true; } else { btnSalesMan.Enabled = false; } rbSchedule.Checked = true; lstActionCode.Enabled = false; InitDate(); LoadData(); }