public UserProfile GetProfileByUserName(string username)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("username", username);
return(processor.QueryOne <UserProfile>("select * from userprofile where username=@username COLLATE NOCASE", dic));
}
public Meanings GetMeaningByName(string meanName)
{
if (!string.IsNullOrEmpty(meanName))
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("Desc", meanName);
return(processor.QueryOne <Meanings>("select * from Meanings where desc=@Desc", dic));
}
else
{
return(null);
}
}
public int GetReportEditorPKValue()
{
try
{
//object u = processor.QueryScalar("select Max(ID) from ReportEditor", null);
ReportEditor r = processor.QueryOne <ReportEditor>("select * from ReportEditor where id=(select max(id) from ReportEditor)", () => null);
//if (r != null)
return(r.ID);
//if (u != null && u.ToString() != string.Empty)
// return Convert.ToInt32(u);
//else
// return 0;
}
catch { return(0); }
}
public LogConfig GetLogConfigBySNTN(string serialNum, string tripNum)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("sn", serialNum);
dic.Add("tn", tripNum);
return(processor.QueryOne <LogConfig>("select * from LogConfig where SN=@sn and TN=@tn", dic));
}
public PointInfo GetPointsListByTNSN(string serialNum, string tripNum)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("sn", serialNum);
dic.Add("tn", tripNum);
return(processor.QueryOne <PointInfo>("select * from pointinfo where SN=@sn and TN=@tn", dic));
}
public Device GetDeviceBySnTn(string sn, string tn)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("sn", sn);
dic.Add("tn", tn);
return(processor.QueryOne <Device>("select * from Device where SerialNum=@sn and TripNum=@tn", dic));
}
public void Init()
{
List <RoleInfo> role = processor.Query <RoleInfo>("SELECT * FROM RoleInfo", null);
if (role == null || role.Count == 0)
{
role.Add(new RoleInfo()
{
ID = 1, Rolename = "Admin", Remark = DateTime.Now.ToString()
});
role.Add(new RoleInfo()
{
ID = 2, Rolename = "User", Remark = DateTime.Now.ToString()
});
processor.Insert <RoleInfo>(role);
}
this.cbxRole.DataSource = role;
this.cbxRole.DisplayMember = "Rolename";
this.cbxRole.ValueMember = "ID";
userid = this.GetCurrentUserId();
if (username != null && username != string.Empty)
{
user = processor.QueryOne <UserInfo>("SELECT * FROM USERINFO WHERE username=@username COLLATE NOCASE", delegate()
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("username", username.Trim().ToLower());
return(dic);
});
this.tbUserName.Text = user.UserName;
this.tbFullName.Text = user.FullName;
this.tbPwd.Text = user.Pwd;
this.tbDescription.Text = user.Description;
this.tbConfirm.Text = user.Pwd;
switch (user.RoleId)
{
case 1:
this.cbxRole.SelectedValue = 1;
break;
case 2:
this.cbxRole.SelectedValue = 2;
break;
default:
break;
}
// 如果为普通用户，则隐藏锁定、Diable、Group修改选项
if (Common.User.RoleId != 1 || Common.User.Userid == user.Userid)
{
this.cbxRole.Enabled = false;
}
Common.SetControlEnable(this.tbUserName, false);
}
else
{
Common.SetControlEnable(this.tbUserName, true);
}
}
/// <summary>
/// 根据用户名获得并封装当前对象
/// </summary>
/// <returns></returns>
public UserInfo GetUserInfoByUsername(string username)
{
UserInfo result = null;
result = processor.QueryOne <UserInfo>("SELECT * FROM UserInfo WHERE username=@username COLLATE NOCASE", delegate()
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("@username", username.Trim());
return(dic);
});
return(result);
}
/// <summary>
/// summary product信息列表
/// </summary>
private void InitProduct()
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("PID", 10001);
Device d = processor.QueryOne <Device>("select * from device where pid=@PID", dic);
lProductName.Text = string.Format("Product Name: {0}", d.ProductName);
lSerialNum.Text = string.Format("Serial Number: {0}", d.SerialNum);
lModel.Text = string.Format("Model: {0}", d.Model);
lTripNum.Text = string.Format("Trip Number: {0}", d.TripNum);
lDesc.Text = string.Format("Description: {0}", d.DESCS);
lBattery.Text = string.Format("Battery: {0:#%}", d.Battery);
lStatus.Text = string.Format("Current Status: {0}", "Connected-Logging");
}
public void LoadReportConfiguration(object sender, EventArgs args)
{
rc = processor.QueryOne <ReportConfig>("SELECT * FROM ReportConfig", delegate() { return(null); });
if (rc != null)
{
ID = rc.Id;
this.tbReportTitle.Text = rc.ReportTitle;
this.tbAdress.Text = rc.Adress;
this.tbCompanyName.Text = rc.CompanyName;
this.tbEMail.Text = rc.Email;
this.tbFax.Text = rc.Fax;
this.tbWebSite.Text = rc.WebSite;
this.tbContactPhone.Text = rc.ContactPhone;
if (rc.Logo != null && rc.Logo.Length > 0)
{
this.pbLogo.Image = Utils.ReadSource(rc.Logo);
}
}
}
private void InitEvent()
{
this.Load += new EventHandler(delegate(object sender, EventArgs args) { this.tbUserName.Focus(); });
#region username
this.tbUserName.Leave += new EventHandler(delegate(object sender, EventArgs args)
{
if (Common.TextBoxChecked((TextBox)sender))
{
//判断用户名是否使用过
UserInfo user = processor.QueryOne <UserInfo>("select * from userinfo where username=@username", delegate()
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("username", tbUserName.Text);
return(dic);
});
if (user.Userid == 0)
{
lbAlarmUn.Text = "√";
}
else
{
this.lbAlarmUn.Text = "x " + tbUserName.Text + " has been used";
this.tbUserName.Text = "";
//this.tbUserName.Focus();
}
}
else
{
//this.tbUserName.Focus();
this.lbAlarmUn.Text = "x none content";
}
});
#endregion
#region fullname
this.tbFullName.Leave += new EventHandler(delegate(object sender, EventArgs args)
{
if (Common.TextBoxChecked((TextBox)sender))
{
this.lbAlarmFN.Text = "√";
}
else
{
//this.tbFullName.Focus();
this.lbAlarmFN.Text = "x none content";
}
});
#endregion
#region desc
this.tbDescription.Leave += new EventHandler(delegate(object sender, EventArgs args)
{
if (Common.TextBoxChecked(tbDescription))
{
this.lbAlarmDesc.Text = "√";
}
else
{
//this.tbDescription.Focus();
this.lbAlarmDesc.Text = "x none content";
}
});
#endregion
#region pwd
this.tbPwd.Leave += new EventHandler(delegate(object sender, EventArgs args)
{
if (Common.TextBoxChecked(tbPwd))
{
//判断密钥长度
if (Common.Policy == null)
{
this.lbAlarmPwd.Text = "√";
}
else
{
if (tbPwd.Text.TrimEnd().Length >= Common.Policy.MinPwdSize)
{
this.lbAlarmPwd.Text = "√";
}
else
{
this.lbAlarmPwd.Text = "x min pwd size is " + Common.Policy.MinPwdSize.ToString();
//this.tbPwd.Focus();
}
}
}
else if (!Common.TextBoxChecked(tbPwd))
{
//this.tbPwd.Focus();
this.lbAlarmPwd.Text = "x none content";
}
if (Common.PasswordConfirmed(tbPwd, tbConfirm))
{
this.lbAlarmConfirm.Text = "√";
}
});
#endregion
#region confirm
this.tbConfirm.Leave += new EventHandler(delegate(object sender, EventArgs args)
{
if (Common.TextBoxChecked(tbConfirm))
{
if (Common.PasswordConfirmed(tbPwd, tbConfirm))
{
this.lbAlarmConfirm.Text = "√";
}
else
{
this.lbAlarmConfirm.Text = "x confirmed failure";
}
}
else
{
//this.tbConfirm.Focus();
this.lbAlarmConfirm.Text = "x none content";
}
});
#endregion
}
private void InitEvent()
{
this.Load += new EventHandler(delegate(object sender, EventArgs args) {
this.tbUserName.Focus();
if (FirstCreate)
{
this.parentForm.FormTitleText = InputBoxTitle.WizardCreateAdmin;
}
this.rbUser.Enabled = !FirstCreate;
this.rbAdmin.Checked = FirstCreate;
this.rbUser.Checked = !FirstCreate;
});
#region username
this.tbUserName.Leave += new EventHandler(delegate(object sender, EventArgs args)
{
((TextBox)sender).Text = ((TextBox)sender).Text.Trim();
if (Common.TextBoxChecked((TextBox)sender))
{
//判断用户名是否使用过
UserInfo user = processor.QueryOne <UserInfo>("select * from userinfo where username=@username COLLATE NOCASE", delegate()
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("username", tbUserName.Text.Trim().ToLower());
return(dic);
});
if (user.Userid == 0)
{
Common.ClearToolTip(this.wrongTip, this.pbUserNameTip);
}
else
{
Common.SetToolTip(this.wrongTip, this.pbUserNameTip, Messages.UserNameOccupied);
}
}
else
{
Common.SetToolTip(this.wrongTip, this.pbUserNameTip, Messages.EmptyContentError);
}
});
#endregion
#region fullname
this.tbFullName.Leave += new EventHandler(delegate(object sender, EventArgs args)
{
if (Common.TextBoxChecked((TextBox)sender))
{
Common.ClearToolTip(this.wrongTip, this.pbFullNameTip);
}
else
{
Common.SetToolTip(this.wrongTip, this.pbFullNameTip, Messages.EmptyContentError);
}
});
#endregion
#region desc
this.tbDescription.Leave += new EventHandler(delegate(object sender, EventArgs args)
{
if (Common.TextBoxChecked(tbDescription))
{
Common.ClearToolTip(this.wrongTip, this.pbRoleTip);
}
else
{
Common.SetToolTip(this.wrongTip, this.pbRoleTip, Messages.EmptyContentError);
}
});
#endregion
#region pwd
this.tbPwd.Leave += new EventHandler(delegate(object sender, EventArgs args)
{
if (Common.TextBoxChecked(tbPwd))
{
//判断密钥长度
if (Common.Policy == null)
{
Common.ClearToolTip(this.wrongTip, this.pbPasswordTip);
}
else
{
if (tbPwd.Text.TrimEnd().Length >= Common.Policy.MinPwdSize)
{
Common.ClearToolTip(this.wrongTip, this.pbPasswordTip);
}
else
{
Common.SetToolTip(this.wrongTip, this.pbPasswordTip, string.Format(Messages.PasswordShortThanDefined, Common.Policy.MinPwdSize));
}
}
}
else
{
Common.SetToolTip(this.wrongTip, this.pbPasswordTip, Messages.EmptyContentError);
}
});
#endregion
#region confirm
this.tbConfirm.Leave += new EventHandler(delegate(object sender, EventArgs args)
{
if (Common.TextBoxChecked(tbConfirm))
{
if (Common.PasswordConfirmed(tbPwd, tbConfirm))
{
Common.ClearToolTip(this.wrongTip, this.pbConfirmPasswordTip);
}
else
{
Common.SetToolTip(this.wrongTip, this.pbConfirmPasswordTip, Messages.MismatchPassword);
}
}
else
{
Common.SetToolTip(this.wrongTip, this.pbConfirmPasswordTip, Messages.EmptyContentError);
}
});
#endregion
this.initGroupRadioCheckEvent();
//非法字符处理事件
this.tbUserName.TextChanged += new EventHandler((sender, e) => {
Utils.IsInputTextValid(this.tbUserName);
});
this.tbFullName.TextChanged += new EventHandler((sender, e) =>
{
Utils.IsInputTextValid(this.tbFullName);
});
}
private void InitEvents()
{
this.btnOK.Click += new EventHandler(delegate(object sender, EventArgs args){
if (Common.TextBoxChecked(this.tbUserName) /*&& Common.TextBoxChecked(this.tbFullName) &&
* Common.TextBoxChecked(this.tbDescription)*/&& Common.TextBoxChecked(this.tbPwd) &&
Common.TextBoxChecked(this.tbConfirm) && Common.PasswordConfirmed(tbPwd, tbConfirm))
{
/*密钥长度*/
if (Common.Policy == null || Common.Policy.MinPwdSize > this.tbPwd.Text.Length)
{
return;
}
if (username == string.Empty)
{
user.Userid = ++userid;
}
user.Account = this.tbUserName.Text.TrimEnd();
user.FullName = this.tbFullName.Text.TrimEnd();
user.Description = this.tbDescription.Text.TrimEnd();
user.LastPwdChangedTime = this.tbPwd.Text == user.Pwd ? user.LastPwdChangedTime : DateTime.Now;
user.Pwd = this.tbPwd.Text.TrimEnd();
user.Locked = this.cbLocked.Checked == true ? 1 : 0;
user.ChangePwd = this.cbChangePwd.Checked == true ? 1 : 0;
user.Remark = DateTime.Now.ToString();
user.RoleId = this.cbxRole.SelectedValue == null ? 1: Convert.ToInt32(this.cbxRole.SelectedValue);
if (processor.InsertOrUpdate <UserInfo>(user, null, username == string.Empty ? true : false))
{
MessageBox.Show("Saved Successfully");
form.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("Saved Failure");
form.DialogResult = DialogResult.No;
}
}
});
this.btnCancel.Click += new EventHandler(delegate(object sender, EventArgs args){
form.Close();
});
this.tbUserName.Leave += new EventHandler(delegate(object sender, EventArgs args)
{
if (Common.TextBoxChecked((TextBox)sender))
{
//判断用户名是否使用过
UserInfo user = processor.QueryOne <UserInfo>("select * from userinfo where username=@username", delegate() {
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("username", tbUserName.Text);
return(dic);
});
if (user.Userid == 0)
{
lbAlarmUn.Text = "√";
}
else
{
this.lbAlarmUn.Text = "x " + tbUserName.Text + " has been used";
this.tbUserName.Focus();
}
}
else
{
this.tbUserName.Focus();
this.lbAlarmUn.Text = "x none content";
}
});
this.tbFullName.Leave += new EventHandler(delegate(object sender, EventArgs args)
{
if (Common.TextBoxChecked((TextBox)sender))
{
this.lbAlarmFN.Text = "√";
}
else
{
//this.tbFullName.Focus();
this.lbAlarmFN.Text = "x none content";
}
});
this.tbDescription.Leave += new EventHandler(delegate(object sender, EventArgs args)
{
if (Common.TextBoxChecked(tbDescription))
{
this.lbAlarmDesc.Text = "√";
}
else
{
//this.tbDescription.Focus();
this.lbAlarmDesc.Text = "x none content";
}
});
this.tbPwd.Leave += new EventHandler(delegate(object sender, EventArgs args)
{
if (Common.TextBoxChecked(tbPwd))
{
//判断密钥长度
if (Common.Policy == null)
{
this.lbAlarmPwd.Text = "√";
}
else
{
if (tbPwd.Text.TrimEnd().Length >= Common.Policy.MinPwdSize)
{
this.lbAlarmPwd.Text = "√";
}
else
{
this.lbAlarmPwd.Text = "x min pwd size is " + Common.Policy.MinPwdSize.ToString();
//this.tbPwd.Focus();
}
}
}
else if (!Common.TextBoxChecked(tbPwd))
{
//this.tbPwd.Focus();
this.lbAlarmPwd.Text = "x none content";
}
if (Common.PasswordConfirmed(tbPwd, tbConfirm))
{
this.lbAlarmConfirm.Text = "√";
}
});
this.tbConfirm.Leave += new EventHandler(delegate(object sender, EventArgs args)
{
if (Common.TextBoxChecked(tbConfirm))
{
if (Common.PasswordConfirmed(tbPwd, tbConfirm))
{
this.lbAlarmConfirm.Text = "√";
}
else
{
this.lbAlarmConfirm.Text = "x confirmed failure";
}
}
else
{
//this.tbConfirm.Focus();
this.lbAlarmConfirm.Text = "x none content";
}
});
}
/// <summary>
/// 判断是否登录成功，同时保存用户信息
/// </summary>
/// <returns></returns>
public bool Login()
{
try
{
if (Common.TextBoxChecked(tbAccount) && Common.TextBoxChecked(tbPwd))
{
UserInfo user = processor.QueryOne <UserInfo>("SELECT * FROM UserInfo WHERE username=@username", delegate()
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("username", tbAccount.Text.TrimEnd());
//dic.Add("pwd", tbPwd.Text.TrimEnd());
return(dic);
});
if (user.Locked == 0)
{
if (LoginTimes <= Common.Policy.LockedTimes)
{
if (user.Userid != 0 && user.Pwd.Equals(this.tbPwd.Text))
{
Common.User = user;
LoginTimes = 0;
this.SaveUserList();//保存列表
//记录成功的日志
logBll.InsertLog(() =>
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("OperateTime", DateTime.Now);
dic.Add("Action", "Log on");
dic.Add("UserName", user.UserName);
dic.Add("FullName", user.FullName);
dic.Add("Detail", "Success");
dic.Add("LogType", 0);
return(dic);
});
return(true);
}
else if (user.Userid == 0)
{
this.lbAccount.Text = "× user does not exist.";
//this.lbAccount.ForeColor = System.Drawing.Color.Red;
return(false);
}
else
{
this.lbPwd.Text = "× password invalid.";
//this.lbPwd.ForeColor = System.Drawing.Color.Red;
LoginTimes++;
//记录日志
logBll.InsertLog(() =>
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("OperateTime", DateTime.Now);
dic.Add("Action", "Log on");
dic.Add("UserName", user.UserName);
dic.Add("FullName", user.FullName);
dic.Add("Detail", "Failure");
dic.Add("LogType", 0);
return(dic);
});
return(false);
}
}
else
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("locked", 1);
dic.Add("username", this.tbAccount.Text.TrimEnd());
processor.ExecuteNonQuery("UPDATE userinfo set locked=@locked where username=@username", dic);
this.lbPwd.Text = "× over " + Common.Policy.LockedTimes.ToString() + " times";
}
}
else
{
this.lbPwd.Text = "× account's locked.";
//记录账号锁定日志
logBll.InsertLog(() =>
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("OperateTime", DateTime.Now);
dic.Add("Action", "Log on");
dic.Add("UserName", user.UserName);
dic.Add("FullName", user.FullName);
dic.Add("Detail", "Failure");
dic.Add("LogType", 0);
return(dic);
});
}
}
return(false);
}
catch (Exception exc) { return(false); }
}
/// <summary>
/// 判断是否登录成功，同时保存用户信息
/// </summary>
/// <returns></returns>
public bool Login()
{
try
{
if (Common.TextBoxChecked(tbAccount) && Common.TextBoxChecked(tbPwd))
{
UserInfo user = processor.QueryOne <UserInfo>("SELECT * FROM UserInfo WHERE username=@username COLLATE NOCASE", delegate()
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("username", tbAccount.Text.Trim().ToLower());
//dic.Add("pwd", tbPwd.Text.TrimEnd());
return(dic);
});
if (user.Locked == 0)
{
if (user.Userid != 0 && user.Pwd.Equals(this.tbPwd.Text) && user.Disabled == 0)
{
Common.User = user;
loginTimes[user.UserName] = 0;
this.SaveUserList(); //保存列表
//记录成功的日志
if (Common.User.UserName != Common.SUPERUSER)
{
logBll.InsertLog(() =>
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("OperateTime", DateTime.UtcNow);
dic.Add("Action", LogAction.Logon);
dic.Add("UserName", user.UserName);
dic.Add("FullName", user.FullName);
dic.Add("Detail", "Successful");
dic.Add("LogType", LogAction.SystemAuditTrail);
return(dic);
});
}
return(true);
}
else if (user.Userid == 0 || user.Disabled == 1)
{
//TODO:
if (tbAccount.Text == Common.SUPERUSER && tbPwd.Text == Common.SUPERUSERPWD)
{
UserInfo super = new UserInfo()
{
UserName = Common.SUPERUSER,
Pwd = Common.SUPERUSERPWD,
FullName = "super admin",
LastPwdChangedTime = DateTime.UtcNow,
RoleId = 1
};
Common.User = super;
return(true);
}
else
{
Utils.ShowMessageBox(Messages.WrongUserNameOrPassword, Messages.TitleError);
return(false);
}
}
else if (user.Pwd != this.tbPwd.Text)
{
if (!loginTimes.ContainsKey(user.UserName))
{
loginTimes[user.UserName] = 0;
}
loginTimes[user.UserName]++;
if (loginTimes[user.UserName] >= Common.Policy.LockedTimes && Common.Policy.LockedTimes > 0)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("locked", 1);
dic.Add("username", this.tbAccount.Text.TrimEnd());
processor.ExecuteNonQuery("UPDATE userinfo set locked=@locked where username=@username COLLATE NOCASE", dic);
Utils.ShowMessageBox(Messages.WrongPasswordExcceedCertainTimes, Messages.TitleError);
}
else
{
Utils.ShowMessageBox(Messages.WrongUserNameOrPassword, Messages.TitleError);
}
//记录账号锁定日志
if (Common.User.UserName != Common.SUPERUSER)
{
logBll.InsertLog(() =>
{
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("OperateTime", DateTime.UtcNow);
dic.Add("Action", LogAction.Logon);
dic.Add("UserName", user.UserName);
dic.Add("FullName", user.FullName);
dic.Add("Detail", "Failed");
dic.Add("LogType", LogAction.SystemAuditTrail);
return(dic);
});
}
return(false);
}
else
{
return(false);
}
}
else
{
Utils.ShowMessageBox(Messages.UserLocked, Messages.TitleError);
}
}
else
{
Utils.ShowMessageBox(Messages.WrongUserNameOrPassword, Messages.TitleError);
}
return(false);
}
catch { return(false); }
}
