/// <summary>
/// get table record
/// <summary>
/// <param name=hostname>hostname</param>
/// <param name=out emsg>return error message</param>
///<returns>get a record detail of logloginhost</returns>
public modLogLoginHost GetItem(string hostname, out string emsg)
{
try
{
//Execute a query to read the categories
string sql = string.Format("select host_name,host_code,register_code,update_user,update_time from log_login_host where host_name='{0}' order by host_name", hostname);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
if (rdr.Read())
{
modLogLoginHost model = new modLogLoginHost();
model.HostName = dalUtility.ConvertToString(rdr["host_name"]);
model.HostCode = dalUtility.ConvertToString(rdr["host_code"]);
model.RegisterCode = dalUtility.ConvertToString(rdr["register_code"]);
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 logloginhost
/// <summary>
/// <param name=out emsg>return error message</param>
///<returns>details of all logloginhost</returns>
public BindingCollection <modLogLoginHost> GetIList(out string emsg)
{
try
{
BindingCollection <modLogLoginHost> modellist = new BindingCollection <modLogLoginHost>();
//Execute a query to read the categories
string sql = "select host_name,host_code,register_code,update_user,update_time from log_login_host order by host_name";
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
modLogLoginHost model = new modLogLoginHost();
model.HostName = dalUtility.ConvertToString(rdr["host_name"]);
model.HostCode = dalUtility.ConvertToString(rdr["host_code"]);
model.RegisterCode = dalUtility.ConvertToString(rdr["register_code"]);
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 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>
/// insert a logloginhost
/// <summary>
/// <param name=mod>model object of logloginhost</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Insert(modLogLoginHost mod, out string emsg)
{
try
{
string sql = string.Format("insert into log_login_host(host_name,host_code,register_code,update_user,update_time)values('{0}','{1}','{2}','{3}',getdate())", mod.HostName, mod.HostCode, mod.RegisterCode, mod.UpdateUser);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = null;
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(false);
}
}
/// <summary>
/// update a logloginhost
/// <summary>
/// <param name=hostname>hostname</param>
/// <param name=mod>model object of logloginhost</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Update(string hostname, modLogLoginHost mod, out string emsg)
{
try
{
string sql = string.Format("update log_login_host set host_code='{0}',register_code='{1}',update_user='******',update_time=getdate() where host_name='{3}'", mod.HostCode, mod.RegisterCode, mod.UpdateUser, hostname);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = null;
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
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;
}
}