private void Login()
{
if (txtUserId.Text.Trim().Length == 0)
{
MessageBox.Show("User Id can not be null!");
txtUserId.Focus();
return;
}
if (txtPwd.Text.Trim().Length == 0)
{
MessageBox.Show("Password can not be null!");
txtPwd.Focus();
return;
}
this.Cursor = Cursors.WaitCursor;
string userid = txtUserId.Text.Trim().ToString();
string strPwd = Util.Encrypt(txtPwd.Text.Trim().ToString(), Util.PWD_MASK);
dalUserList dal = new dalUserList();
bool ret = dal.Login(userid, strPwd, out Util.emsg);
if (ret)
{
modUserList mod = dal.GetItem(userid);
Util.UserId = mod.UserId;
Util.UserName = mod.UserName;
Util.RoleId = mod.RoleId;
dalRoleList role = new dalRoleList();
modRoleList modrole = role.GetItem(mod.RoleId, out Util.emsg);
Util.RoleDesc = modrole.RoleDesc;
Util.UserStatus = mod.Status;
ini.IniWriteValue("login", "userid", userid);
dalLogLoginHost bllhost = new dalLogLoginHost();
modLogLoginHost modhost = new modLogLoginHost();
modhost.HostName = Environment.MachineName;
modhost.HostCode = Util.HOST_CODE;
modhost.UpdateUser = Util.UserId;
if (bllhost.Exists(modhost.HostName, out Util.emsg))
{
bllhost.Update(modhost.HostName, modhost, out Util.emsg);
}
else
{
bllhost.Insert(modhost, out Util.emsg);
}
this.DialogResult = DialogResult.OK;
this.Cursor = Cursors.Default;
return;
}
else
{
//this.DialogResult = DialogResult.Cancel;
this.Cursor = Cursors.Default;
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
/// <summary>
/// get all qstasklist
/// <summary>
/// <param name=validonly>validonly</param>
///<returns>Details about all RoleList</returns>
public BindingCollection <modRoleList> GetIList(bool validonly, out string emsg)
{
try
{
string sql;
string getwhere = validonly == true ? "and status=1" : string.Empty;
sql = "select role_id,role_desc,status,update_user,update_time from sys_role_list where 1=1 " + getwhere + "order by role_id";
BindingCollection <modRoleList> modellist = new BindingCollection <modRoleList>();
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
modRoleList model = new modRoleList();
model.RoleId = rdr["role_id"].ToString();
model.RoleDesc = rdr["role_desc"].ToString();
model.Status = dalUtility.ConvertToInt(rdr["status"]);
model.UpdateUser = rdr["update_user"].ToString();
model.UpdateTime = DateTime.Parse(rdr["update_time"].ToString());
modellist.Add(model);
}
}
emsg = "";
return(modellist);
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
/// <summary>
/// get RoleList by RoleId
/// <summary>
/// <param name=RoleId>RoleId</param>
///<returns>get record of RoleList</returns>
///<returns>Details about all RoleList</returns>
public modRoleList GetItem(string RoleId, out string emsg)
{
try
{
string sql = string.Format("select role_id,role_desc,status,update_user,update_time from sys_role_list where role_id = '{0}'", RoleId);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
if (rdr.Read())
{
modRoleList model = new modRoleList();
model.RoleId = rdr["role_id"].ToString();
model.RoleDesc = rdr["role_desc"].ToString();
model.Status = dalUtility.ConvertToInt(rdr["status"]);
model.UpdateUser = rdr["update_user"].ToString();
model.UpdateTime = DateTime.Parse(rdr["update_time"].ToString());
emsg = string.Empty;
return(model);
}
else
{
emsg = "";
return(null);
}
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
private void DBGrid_SelectionChanged(object sender, EventArgs e)
{
if (DBGrid.CurrentRow != null)
{
modRoleList mod = (modRoleList)DBGrid.CurrentRow.DataBoundItem;
txtRoleId.Text = mod.RoleId;
txtRoleDesc.Text = mod.RoleDesc;
cboStatus.SelectedIndex = Convert.ToInt32(mod.Status);
FindText = mod.RoleId;
}
}
protected override void Find()
{
for (int i = 0; i < DBGrid.Rows.Count; i++)
{
modRoleList mod = (modRoleList)DBGrid.Rows[i].DataBoundItem;
if (mod.RoleId.CompareTo(FindText) == 0)
{
DBGrid.CurrentCell = DBGrid.Rows[i].Cells[0];
DBGrid_SelectionChanged(null, null);
return;
}
}
}
protected override bool Save()
{
if (string.IsNullOrEmpty(txtRoleId.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("role id") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtRoleId.Focus();
return(false);
}
if (string.IsNullOrEmpty(txtRoleDesc.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("role desc") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtRoleDesc.Focus();
return(false);
}
modRoleList mod = new modRoleList();
mod.RoleId = txtRoleId.Text.Trim();
mod.RoleDesc = txtRoleDesc.Text.Trim();
mod.Status = cboStatus.SelectedIndex;
mod.UpdateUser = Util.UserId;
bool ret = false;
if (_status == 1)
{
ret = _dal.Insert(mod, out Util.emsg);
}
else if (_status == 2)
{
ret = _dal.Update(txtRoleId.Text, mod, out Util.emsg);
}
if (ret)
{
Util.ChangeStatus(this, true);
LoadData();
FindText = mod.RoleId;
Find();
}
return(ret);
}
/// <summary>
/// update a RoleList
/// <summary>
/// <param name=RoleId>RoleId</param>
/// <param name=mod>mod</param>
/// <returns>true/false</returns>
public bool Update(string RoleId, modRoleList mod, out string emsg)
{
try
{
string sql = string.Format("update sys_role_list set role_desc='{0}',status={1},update_user='******',update_time=getdate() where role_id='{3}'", mod.RoleDesc, mod.Status, mod.UpdateUser, RoleId);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = "";
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message.ToString());
return(false);
}
}
/// <summary>
/// insert a RoleList
/// <summary>
/// <param name=mod>mod</param>
/// <returns>true/false</returns>
public bool Insert(modRoleList mod, out string emsg)
{
try
{
string sql = string.Format("insert into sys_role_list(role_id,role_desc,status,update_user,update_time)values('{0}','{1}',{2},'{3}',getdate())", mod.RoleId, mod.RoleDesc, mod.Status, mod.UpdateUser);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = "";
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message.ToString());
return(false);
}
}
private void Login()
{
if (txtSystemTime.Text.Trim() != txtServerTime.Text.Trim())
{
DateTime dt1 = DateTime.Parse(txtSystemTime.Text);
DateTime dt2 = DateTime.Parse(txtServerTime.Text);
TimeSpan ts = new TimeSpan(dt1.Ticks - dt2.Ticks);
if (Math.Abs(ts.Days) > 1 || Math.Abs(ts.Minutes) > 2 || Math.Abs(ts.Hours) > 1 || Math.Abs(ts.Days) > 1)
{
MessageBox.Show(clsTranslate.TranslateString("local time must equal to server time,please adjust your system time first!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
txtSystemTime.Focus();
return;
}
}
if (cboPeriodList.Items.Count == 0)
{
btnNew_Click(null, null);
return;
}
if (txtUserId.Text.Trim().Length == 0)
{
MessageBox.Show("User Id can not be null!");
txtUserId.Focus();
return;
}
if (txtPwd.Text.Trim().Length == 0)
{
MessageBox.Show("Password can not be null!");
txtPwd.Focus();
return;
}
this.Cursor = Cursors.WaitCursor;
string userid = txtUserId.Text.Trim().ToString();
string strPwd = Util.Encrypt(txtPwd.Text.Trim().ToString(), Util.PWD_MASK);
dalUserList dal = new dalUserList();
bool ret = dal.Login(userid, strPwd, out Util.emsg);
if (ret)
{
modUserList mod = dal.GetItem(userid);
Util.UserId = mod.UserId;
Util.UserName = mod.UserName;
Util.RoleId = mod.RoleId;
dalRoleList role = new dalRoleList();
modRoleList modrole = role.GetItem(mod.RoleId, out Util.emsg);
Util.RoleDesc = modrole.RoleDesc;
Util.UserStatus = mod.Status;
ini.IniWriteValue("login", "userid", userid);
dalAccCurrencyList dalcur = new dalAccCurrencyList();
modAccCurrencyList modcur = dalcur.GetOwnerItem(out Util.emsg);
Util.Currency = modcur.Currency;
dalLogLoginHost bllhost = new dalLogLoginHost();
modLogLoginHost modhost = new modLogLoginHost();
modhost.HostName = Environment.MachineName;
Util.modperiod = (modAccPeriodList)cboPeriodList.SelectedItem;
clsLxms.CheckSoftwareRegister();
if (Util.SOFT_REGISTER)
{
modhost.RegisterCode = Util.REGISTER_CODE;
}
else
{
modhost.RegisterCode = string.Empty;
if (cboPeriodList.Items.Count >= 7)
{
frmSoftRegister frm = new frmSoftRegister();
if (frm.ShowDialog() != DialogResult.OK)
{
return;
}
}
}
modhost.HostCode = Util.HOST_CODE;
modhost.UpdateUser = Util.UserId;
if (bllhost.Exists(modhost.HostName, out Util.emsg))
{
bllhost.Update(modhost.HostName, modhost, out Util.emsg);
}
else
{
bllhost.Insert(modhost, out Util.emsg);
}
this.DialogResult = DialogResult.OK;
this.Cursor = Cursors.Default;
return;
}
else
{
//this.DialogResult = DialogResult.Cancel;
this.Cursor = Cursors.Default;
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
