/// <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();
}
