/// <summary>
/// 下载zc_branch_total数据
/// </summary>
/// <param name="count"></param>
void DownloadZcBranchTotalData()
{
BranchZcBranchTotalService branchService = new BranchZcBranchTotalService();
branchService.DeleteAll();
ZcBranchTotalService service = new ZcBranchTotalService();
List <ZcBranchTotal> list = service.FindAll();
branchService.AddZcBranchTotal(list);
}
private void loginButton_Click(object sender, EventArgs e)
{
string username = this.userNameTextBox.Text;
string pass = this.userPasswordTextBox.Text;
if (username.Equals("") || pass.Equals(""))
{
promptPanel.Show();
//MessageBox.Show("用户名或者密码不能为空!");
return;
}
string queryString = "";
//调用Md5 获取加密后的密码
string password = MD5Util.GetMd5(pass);
//判断当前分店系统是否已获取自编码
DownloadIdentifyService identifyService = new DownloadIdentifyService();
code = identifyService.getIdCode();
if (string.IsNullOrEmpty(code))
{
System.Guid guid = new Guid();
guid = Guid.NewGuid();
code = guid.ToString();
//SetCode setCode = new SetCode(code);
//setCode.ShowDialog();
//将系统编码存入本地
identifyService.setIdCode(code);
code_flag = true;
}
///业务逻辑判断
/// 1判断是否是初始化第一次登陆
if (identifyService.IsFirst())
{
///需要连接远程Oracle服务器进行用户的验证
///2 判断网络是否连通
if (PingTask.IsConnected)
{
///3 用户账号密码验证
queryString = "select password,id,name from ctp_user where name ='" + username + "'";
//获取数据库连接
OracleConnection connection = OracleUtil.OpenConn();
OracleCommand command = new OracleCommand(queryString);
command.Connection = connection;
try
{
var reader = command.ExecuteReader();
if (reader.Read())
{
string confirmPassword = string.Format("{0}", reader["password"]);
if (password.Equals(confirmPassword))
{
LoginUserInfo.id = reader.IsDBNull(1) ? string.Empty : reader.GetString(1);
LoginUserInfo.name = reader.IsDBNull(2) ? string.Empty : reader.GetString(2);
loadLoginUserInfo();
identifyService.setBranchTotalId();
//上传分店系统编码
if (code_flag && !code.Equals(""))
{
//获取当前分店信息
ZcBranchTotalService branchTotal = new ZcBranchTotalService();
ZcBranchTotal zcBranchTotal = branchTotal.FindOfAll(LoginUserInfo.branchCode);
//将系统编码上传与分店绑定
SetCodeToBranchService setCodeToBranchService = new SetCodeToBranchService();
setCodeToBranchService.setIdCodeToBranch(code, zcBranchTotal, LoginUserInfo.branchId);
}
//MessageBox.Show(code_flag + ":" + code + ":" + LoginUserInfo.branchName + ":" + LoginUserInfo.branchId);
//用户名，密码验证成功
this.DialogResult = DialogResult.OK;
}
else
{
promptPanel.Show();
//MessageBox.Show("用户名或者密码输入错误,请重新输入!");
}
}
else
{
promptPanel.Show();
//MessageBox.Show("用户名或者密码输入错误,请重新输入!");
}
}
catch (Exception ex)
{
log.Error("获取当前登录用户信息失败", ex);
}
finally
{
OracleUtil.CloseConn(connection);
}
}
else
{
MessageBox.Show("首次登录系统会进行初始化的数据下载，请检查网络状态，重新登陆!");
return;
}
}
else
{
///表示已经初始化过系统，系统里面有用户表可以进行登陆判断
///判断是否需要下载数据 并且网络是否连通
if (identifyService.NeedDownload() && (!PingTask.IsConnected))
{
///表示需要下载数据，并且网络未连通
///今日首次登陆
MessageBox.Show("每日首次登录系统会进行订单等数据的下载，请检查网络状态，重新登陆!");
return;
}
else
{
queryString = "select a.name,a.id,a.password from ctp_user a left join zc_user_info b on a.id = b.user_id "
+ " left join download_identify c on b.branch_name_id = c.branch_id "
+ " where c.id = '1' and a.name = '" + username + "'";
/// 1 需要下载数据，网络通 2不需要下载数据， 网络通 3不需要下载数据，网络不通
MysqlDBHelper dbHelper = new MysqlDBHelper();
MySqlConnection conn = null;
MySqlCommand cmd = new MySqlCommand();
try
{
conn = dbHelper.GetConnection();
cmd.CommandText = queryString;
cmd.Connection = conn;
var reader = cmd.ExecuteReader();
if (reader.Read())
{
string confirmPassword = string.Format("{0}", reader["password"]);
if (password.Equals(confirmPassword))
{
LoginUserInfo.id = reader.IsDBNull(1) ? string.Empty : reader.GetString(1);
LoginUserInfo.name = username;
MysqlloadLoginUserInfo();
//用户名，密码验证成功
this.DialogResult = DialogResult.OK;
}
else
{
promptPanel.Show();
//MessageBox.Show("用户名或者密码输入错误,请重新输入!");
}
}
else
{
promptPanel.Show();
//MessageBox.Show("用户名或者密码输入错误,请重新输入!");
}
}
catch (Exception ex)
{
log.Error("查询当前登录账号信息失败", ex);
}
}
}
}
