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