/// <summary>
///
/// </summary>
/// <param name="cKey"></param>
/// <returns></returns>
public static string GetMenuClass(string cKey)
{
using (var cmd = new SqlCommand(@"select cClass from BFunction WHERE cFunction=@cFunction"))
{
cmd.Parameters.AddWithValue("@cFunction", cKey);
var wf = new WmsFunction(Properties.Settings.Default.PDACON);
return(wf.ReturnFirstSingle(cmd));
}
}
private void OK_Login()
{
if (string.IsNullOrEmpty(WmsConstring))
{
MessageBox.Show(@"服务器填写错误，或者服务器端未配置正确！", @"注意", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
lblLogin.Image = Properties.Resources.LoginForm_login_btn_click;
if (string.IsNullOrEmpty(utxtUser.Text.Trim()) || string.IsNullOrEmpty(utxtPassword.Text))
{
MessageBox.Show(@"用户名和密码必填！", @"注意", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var con = new SqlConnection(WmsConstring);
var cmd = new SqlCommand
{
Connection = con,
CommandText =
"select uName,uRole,uCode from BUser where (uName=@uName or uCode=@uName) and uPassword=@uPassword"
};
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@uName", utxtUser.Text);
cmd.Parameters.AddWithValue("@uPassword", WmsFunction.GetMd5Hash(utxtPassword.Text));
con.Open();
var dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (dr.Read()) //直接登陆
{
Account = "";
Server = "";
Properties.Settings.Default.cUser = utxtUser.Text;
Properties.Settings.Default.cServer = Server;
Properties.Settings.Default.cAccount = Account;
Properties.Settings.Default.Save();
Lname = dr["uName"].ToString(); //把登陆名和登陆服务器保存到静态变量中
Ltime = DateTime.Now;
Lrole = dr["uRole"].ToString();
LCode = dr["uCode"].ToString();
dr.Close();
Hide();
var pdaMain = new PDAMain(this);
pdaMain.ShowDialog();
}
else
{
MessageBox.Show(@"用户名或密码错误，请联系管理员！", @"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
/// <summary>
///
/// </summary>
/// <param name="cKey"></param>
/// <returns></returns>
public static string GetMenuClass(string cKey)
{
using (var cmd = new SqlCommand(@"select cClass from BFunction WHERE cFunction=@cFunction"))
{
cmd.Parameters.AddWithValue("@cFunction", cKey);
var wf = new WmsFunction(Properties.Settings.Default.PDACON);
return wf.ReturnFirstSingle(cmd);
}
}
