public ZcBranchTotal FindOfAll(string id) { OracleConnection conn = null; ZcBranchTotal obj = new ZcBranchTotal(); try { conn = OracleUtil.OpenConn(); string sql = "select * from ZC_BRANCH_TOTAL where branch_code ='" + id + "'"; OracleCommand command = new OracleCommand(sql); command.Connection = conn; var reader = command.ExecuteReader(); while (reader.Read()) { obj.Id = reader.IsDBNull(0) ? string.Empty : reader.GetString(0); obj.CreateTime = reader.IsDBNull(1) ? default(DateTime) : reader.GetDateTime(1); obj.UpdateTime = reader.IsDBNull(2) ? default(DateTime) : reader.GetDateTime(2); obj.BranchCode = reader.IsDBNull(3) ? string.Empty : reader.GetString(3); obj.BranchName = reader.IsDBNull(4) ? string.Empty : reader.GetString(4); obj.DelFlag = reader.IsDBNull(5) ? string.Empty : reader.GetString(5); obj.Money = reader.IsDBNull(6) ? string.Empty : reader.GetString(6); obj.CustomerId = reader.IsDBNull(7) ? string.Empty : reader.GetString(7); obj.ZoningId = reader.IsDBNull(8) ? string.Empty : reader.GetString(8); } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { OracleUtil.CloseConn(conn); } return(obj); }
public void setIdCodeToBranch(string code, ZcBranchTotal zcBranchTotal, string id) { OracleConnection conn = null; OracleTransaction tran = null; OracleCommand cmd = new OracleCommand(); string sql = "insert into zc_branchId_info (id,createTime, updateTime,branch_name_id, branch_selfcode) values (:id, :createTime, :updataTime,:branch_name, :branch_selfcode)"; try { conn = OracleUtil.OpenConn(); tran = conn.BeginTransaction(); cmd.CommandText = sql; cmd.Connection = conn; cmd.Parameters.Add(":id", Guid.NewGuid().ToString()); cmd.Parameters.Add(":createTime", DateTime.Now); cmd.Parameters.Add(":updateTime", DateTime.Now); cmd.Parameters.Add(":branch_name", zcBranchTotal.Id); cmd.Parameters.Add(":branch_selfcode", code); cmd.ExecuteNonQuery(); tran.Commit(); } catch (Exception ex) { tran.Rollback(); log.Error("上传系统编码信息发生异常", ex); } finally { tran.Dispose(); cmd.Dispose(); OracleUtil.CloseConn(conn); } }
public List <ZcBranchTotal> FindAll() { List <ZcBranchTotal> list = new List <ZcBranchTotal>(); OracleConnection conn = null; try { conn = OracleUtil.OpenConn(); string sql = "select ID,CREATETIME,UPDATETIME,BRANCH_CODE,BRANCH_NAME,DELFLAG,MONEY,CUSTOMER_ID,ZONING_ID from ZC_BRANCH_TOTAL"; OracleCommand command = new OracleCommand(sql); command.Connection = conn; var reader = command.ExecuteReader(); while (reader.Read()) { ZcBranchTotal obj = new ZcBranchTotal(); obj.Id = reader.IsDBNull(0) ? string.Empty : reader.GetString(0); obj.CreateTime = reader.IsDBNull(1) ? default(DateTime) : reader.GetDateTime(1); obj.UpdateTime = reader.IsDBNull(2) ? default(DateTime) : reader.GetDateTime(2); obj.BranchCode = reader.IsDBNull(3) ? string.Empty : reader.GetString(3); obj.BranchName = reader.IsDBNull(4) ? string.Empty : reader.GetString(4); obj.DelFlag = reader.IsDBNull(5) ? string.Empty : reader.GetString(5); obj.Money = reader.IsDBNull(6) ? string.Empty : reader.GetString(6); obj.CustomerId = reader.IsDBNull(7) ? string.Empty : reader.GetString(7); obj.ZoningId = reader.IsDBNull(8) ? string.Empty : reader.GetString(8); list.Add(obj); } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { OracleUtil.CloseConn(conn); } return(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); } } } }
public void setIdCodeToBranch(string code, ZcBranchTotal zcBranchTotal, string id) { SetCodeToBranchDao dao = new SetCodeToBranchDao(); dao.setIdCodeToBranch(code, zcBranchTotal, id); }