/// <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); } } } }