public static List <SUrlAttribute> FetchObject(MysqlDBHelper helper) { initMap(); List <SUrlAttribute> rtnResult = new List <SUrlAttribute>(); String cmdString = buildQueryCmd(); MySqlCommand cmd = new MySqlCommand(cmdString, helper.DbConnector); //查询结果读取器 MySqlDataReader reader = null; try { reader = cmd.ExecuteReader(); while (reader.Read()) { SUrlAttribute cfg = new SUrlAttribute(); for (int index = 0; index < MapList.Count; index++) { Attr2FieldMap map = MapList[index]; Attr2FieldMap.setValue(cfg, reader[index], map.Attrbute); } rtnResult.Add(cfg); } } catch (Exception ex) { } finally { if (reader != null) { reader.Close(); } } return(rtnResult); }
public static string ExcuteProcedure(string _pStr) { using (MySqlConnection cn = MysqlDBHelper.OpenConnection()) { MySqlTransaction _txn = cn.BeginTransaction(); try { string _sql = _pStr.Substring(5, _pStr.Length - 7); MySqlParameter _p1 = new MySqlParameter(":1", MySqlDbType.VarChar, 1000); _p1.Direction = ParameterDirection.Output; //OracleCommand _cmd = new OracleCommand(_sql, cn); // // //_cmd.ExecuteNonQuery(); MysqlDBHelper.ExecuteNonQuery(cn, CommandType.Text, _sql, _p1); _txn.Commit(); return(_p1.Value.ToString()); } catch (InvalidCastException ex) { string _errmsg = string.Format("执行命令嵌入的命令出错,错误信息为:{0}!SQL语句:{1}", ex.Message, _pStr); //OracleLogWriter.WriteSystemLog(_errmsg, "ERROR"); _txn.Rollback(); return(""); } catch (MySqlException ex) { string _errmsg = string.Format("执行命令嵌入的命令出错,错误信息为:{0}!SQL语句:{1}", ex.Message, _pStr); //OracleLogWriter.WriteSystemLog(_errmsg, "ERROR"); _txn.Rollback(); return(""); } catch (Exception ex) { string _errmsg = string.Format("执行命令嵌入的命令出错,错误信息为:{0}!SQL语句:{1}", ex.Message, _pStr); //OracleLogWriter.WriteSystemLog(_errmsg, "ERROR"); _txn.Rollback(); return(""); } } }
/// <summary> /// 根据条件获取单个符合条件的订单,会员信息。传入CustomerDelivery页面-退款 /// </summary> /// <param name="searchString"></param> /// <param name="customerDelivery"></param> public void GetReturnOrderInfo(string searchString, CustomerDelivery customerDelivery) { MysqlDBHelper dbHelper = new MysqlDBHelper(); //string sql = "select a.id, a.consignee, a.cansignphone, b.associator_cardnumber, a.ORDERAMOUNT from zc_order_transit a left join zc_associator_info b on a.member_id = b.id where a.orderstatus = '" + Constant.ORDER_STATUS_FININSH + "' "; string sql = "select a.id, a.consignee, a.cansignphone, b.associator_cardnumber, a.ORDERAMOUNT from zc_order_history a left join zc_associator_info b on a.member_id = b.id where a.orderstatus in ('" + Constant.ORDER_STATUS_FININSH + "','" + Constant.ORDER_STATUS_PART_REFUSE + "') "; if (searchString != "") { ///根据条件查询 sql += " and ( a.consignee like '%" + searchString + "%' or a.cansignphone like '%" + searchString + "%' or b.associator_cardnumber like '%" + searchString + "%' ) "; } MySqlConnection conn = null; MySqlCommand cmd = new MySqlCommand(); try { conn = dbHelper.GetConnection(); cmd.Connection = conn; cmd.CommandText = sql; MySqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { string id = reader.IsDBNull(0) ? string.Empty : reader.GetString(0); string name = reader.IsDBNull(1) ? string.Empty : reader.GetString(1); string phone = reader.IsDBNull(2) ? string.Empty : reader.GetString(2); string card = reader.IsDBNull(3) ? string.Empty : reader.GetString(3); string amount = reader.IsDBNull(4) ? string.Empty : reader.GetString(3); customerDelivery.setinform(id, amount, name, phone, card); } } catch (Exception ex) { log.Error("获取订单信息发送异常", ex); } finally { cmd.Dispose(); dbHelper.CloseConnection(conn); } }
/// <summary> /// 加载商品 /// </summary> private void loadGoods() { string sql = "select sum(nums) as nums,name,sum(g_price*nums) as totalprice,classify_name,goods_unit,delFlag,goods_specifications,serialNumber,g_price as actualnums,goodsfile_id,goods_class_id,g_price, sortenum, address_id from " + " (select a.goods_state, a.nums, b.goods_name as name ,b.goods_specifications,b.goods_unit,a.g_price,b.id as goodsfile_id,b.delFlag,b.serialNumber,c.classify_name,b.goods_class_id,b.goods_supplier_id ,e.sortenum, e.address as address_id " + " from zc_order_transit_item a left join zc_goods_master b on a.goodsfile_id = b.id left join zc_classify_info c on b.goods_class_id = c.id left join (select sum(sortenum) as sortenum, address, goods_id from zc_order_sorte group by goods_id) e on a.GOODSFILE_ID = e.goods_id " + " ) as d where address_id ='" + LoginUserInfo.street + "' group by name,delFlag,classify_name,goods_unit,goods_specifications,serialNumber,g_price,goodsfile_id,goods_class_id "; try { MysqlDBHelper dbHelper = new MysqlDBHelper(); DataSet ds = dbHelper.GetDataSet(sql, "zc_order_transit_item"); itemDataGridView.AutoGenerateColumns = false; itemDataGridView.DataSource = ds; itemDataGridView.DataMember = "zc_order_transit_item"; itemDataGridView.CurrentCell = null;//不默认选中 } catch (Exception ex) { log.Error("加载订单中商品时发生错误", ex); } }
/// <summary> /// 取指标的sql语句 /// </summary> /// <param name="guideLineId"></param> /// <returns></returns> public static string GetGuidelineMethod(string guideLineId) { MySqlParameter[] param = { new MySqlParameter(":Id", MySqlDbType.Decimal) }; try { param[0].Value = decimal.Parse(guideLineId); object sfobj = MysqlDBHelper.ExecuteScalar(MysqlDBHelper.conf, CommandType.Text, SqlGetGuideLineMethod, param); if (sfobj == null || sfobj == DBNull.Value) { return(""); } return(sfobj.ToString()); } catch (Exception e) { string errorMessage = string.Format("取指标[{0}]的sql语句出错,错误信息为{1}", guideLineId, e.Message); //OracleLogWriter.WriteSystemLog(errorMessage, "ERROR"); return(""); } }
private void GCSupplier_Load(object sender, EventArgs e) { try { string sql = "select * from zc_provider_info order by id asc;"; MysqlDBHelper dbHelper = new MysqlDBHelper(); DataSet ds = dbHelper.GetDataSet(sql, "zc_provider_info"); //MessageBox.Show("1", "提示", MessageBoxButtons.OK); TreeNode treeNode = new TreeNode(); treeNode.Text = "商品供应商"; treeNode.Name = "0"; treeNode.ImageIndex = 0; treeNode.SelectedImageIndex = 0; supplierTreeView.Nodes.Add(treeNode); supplierTreeView.SelectedNode = supplierTreeView.TopNode; if (ds != null) { foreach (DataRow dr in ds.Tables[0].Rows) { treeNode = new TreeNode(); treeNode.Text = dr["provider_nickName"].ToString(); treeNode.Name = dr["ID"].ToString(); treeNode.ImageIndex = 1; treeNode.SelectedImageIndex = 1; supplierTreeView.SelectedNode = supplierTreeView.TopNode; supplierTreeView.SelectedNode.Nodes.Add(treeNode); } supplierTreeView.SelectedNode = supplierTreeView.TopNode; //最顶端节点选中 supplierTreeView.ExpandAll(); } } catch (Exception ex) { log.Error("绑定数据源失败", ex); } finally { asflag = true; } }
/// <summary> /// 取指标的sql语句 /// </summary> /// <param name="guideLineId"></param> /// <returns></returns> public async static Task <string> GetGuidelineMethod(string guideLineId) { try { MySqlParameter[] param = { new MySqlParameter("@Id", MySqlDbType.Int64) }; param[0].Value = Convert.ToInt64(guideLineId); object sfobj = await MysqlDBHelper.ExecuteScalar(MysqlDBHelper.conf, CommandType.Text, SqlGetGuideLineMethod, param); if (sfobj == null || sfobj == DBNull.Value) { return(""); } return(sfobj.ToString()); } catch (Exception e) { string errorMessage = string.Format("取指标[{0}]的sql语句出错,错误信息为{1}", guideLineId, e.Message); MysqlLogWriter.WriteSystemLog(errorMessage, "ERROR"); return(""); } }
private static string GetViewIDByName(string _viewName) { using (MySqlConnection cn = MysqlDBHelper.OpenConnection()) { MySqlTransaction _txn = cn.BeginTransaction(); try { string[] _fs = _viewName.Split('.'); MySqlCommand _cmd = new MySqlCommand(SQL_GetViewIDByName, cn); _cmd.Parameters.Add(new MySqlParameter("@NS", _fs[0])); _cmd.Parameters.Add(new MySqlParameter("@VN", _fs[1])); string _s = _cmd.ExecuteScalar().ToString(); return(_s); } catch (Exception ex) { string _errmsg = string.Format("执行不错查询模型ID的命令出错,错误信息为:{0}!SQL语句:{1}", ex.Message, SQL_GetViewIDByName); MysqlLogWriter.WriteSystemLog(_errmsg, "ERROR"); return(""); } } }
/// <summary> /// 展示商品列表 /// </summary> private void queryGoods() { try { string sql = "select a.SERIALNUMBER ,a.goods_name,a.goods_unit,a.goods_specifications,a.goods_price,a.remark,a.id from zc_goods_master a " + "left join zc_classify_info b on a.goods_class_id = b.id " + "left join zc_classify_info c on a.goods_brand_id = c.id " + "left join zc_provider_info d on a.goods_supplier_id = d.id where 1=1 "; sql += addNodeConditions(); sql += addTextConditions(); sql += addSizeConditions(); sql += ";"; MysqlDBHelper dbHelper = new MysqlDBHelper(); DataSet ds = dbHelper.GetDataSet(sql, "zc_goods_master"); goodsDataGridView.DataSource = ds; goodsDataGridView.DataMember = "zc_goods_master"; } catch (Exception ex) { log.Error("展示商品列表绑定数据失败", ex); } }
/// <summary> /// 加载收货过的商品信息列表 /// </summary> private void loadHarvestGoods() { DateTime first = DateTime.Today; DateTime last = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd 23:59:59")); MysqlDBHelper dbHelper = new MysqlDBHelper(); MySqlConnection conn = null; string sql = "select serialNumber , name, classify, goods_unit, goods_specifications, goods_price as g_price, nums, actual_quantity, order_amount, receive_amount,sortenum from daily_receive_goods where createTime between @first and @last "; MySqlCommand cmd = new MySqlCommand(); try { conn = dbHelper.GetConnection(); cmd.Connection = conn; cmd.CommandText = sql; cmd.Parameters.AddWithValue("@first", first); cmd.Parameters.AddWithValue("@last", last); DataSet ds = new DataSet(); MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(ds, "daily_receive_goods"); receiveAmount.DataPropertyName = "receive_amount"; actualQuantity.DataPropertyName = "actual_quantity"; orderAmount.DataPropertyName = "order_amount"; classify.DataPropertyName = "classify"; actualQuantity.ReadOnly = true; itemDataGridView.DataSource = ds; itemDataGridView.DataMember = "daily_receive_goods"; itemDataGridView.CurrentCell = null;//不默认选中 } catch (Exception ex) { log.Error("获取当天收货后的商品信息失败", ex); } finally { cmd.Dispose(); dbHelper.CloseConnection(conn); } }
/// <summary> /// 获取条件查询的记录数量-退款 /// </summary> /// <param name="searchString"></param> /// <returns></returns> public int GetReturnOrderCounts(string searchString) { int count = 0; MysqlDBHelper dbHelper = new MysqlDBHelper(); //string sql = "select count(1) from zc_order_transit a left join zc_associator_info b on a.member_id = b.id where a.orderstatus = '" + Constant.ORDER_STATUS_FININSH + "' "; //string sql = "select count(1) from zc_order_history a left join zc_associator_info b on a.member_id = b.id where a.orderstatus not in ('" + Constant.ORDER_STATUS_ALL_REFUSE + "','" + Constant.ORDER_STATUS_PART_REFUSE + "','" + Constant.ORDER_STATUS_ALL_REFUND + "','" + Constant.ORDER_STATUS_PART_REFUND + "') "; string sql = "select count(1) from zc_order_history a left join zc_associator_info b on a.member_id = b.id where a.orderstatus in ('" + Constant.ORDER_STATUS_FININSH + "','" + Constant.ORDER_STATUS_PART_REFUSE + "') "; if (searchString != "") { ///根据条件查询 sql += " and ( a.consignee like '%" + searchString + "%' or a.cansignphone like '%" + searchString + "%' or b.associator_cardnumber like '%" + searchString + "%' ) "; } MySqlConnection conn = null; MySqlCommand cmd = new MySqlCommand(); try { conn = dbHelper.GetConnection(); cmd.Connection = conn; cmd.CommandText = sql; MySqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { count = reader.IsDBNull(0) ? default(int) : reader.GetInt32(0); } } catch (Exception ex) { log.Error("获取条件查询的订单数量发生异常", ex); } finally { cmd.Dispose(); dbHelper.CloseConnection(conn); } return(count); }
public static DataTable FillResultData(string _selectStr, string _tableName, ref int _count) { _count = 0; DataTable _t = new DataTable(_tableName); using (MySqlConnection cn = MysqlDBHelper.OpenConnection()) { try { _t = FillResultData(_selectStr, _tableName, cn); _count = _t.Rows.Count; } catch (InvalidCastException ex) { string _errmsg = string.Format("执行SQL语句出错,错误信息为:{0}!\n查询语句为:{1}\n:", ex.Message, _selectStr); //OracleLogWriter.WriteSystemLog(_errmsg, "ERROR"); } catch (MySqlException ex) { string _errmsg = string.Format("执行SQL语句出错,错误信息为:{0}!\n查询语句为:{1}\n:", ex.Message, _selectStr); //OracleLogWriter.WriteSystemLog(_errmsg, "ERROR"); } catch (Exception e) { string _errmsg = string.Format("执行SQL语句出错,错误信息为:{0}!\n查询语句为:{1}\n:", e.Message, _selectStr); //OracleLogWriter.WriteSystemLog(_errmsg, "ERROR"); } finally { cn.Close(); } } return(_t); }
private void SpiderConfig_Load(object sender, EventArgs e) { _dbHelper = new MysqlDBHelper(); if (!_dbHelper.OpenDb()) { MessageBox.Show(""); return; } Thread productThread = new Thread(() => { _scList = SConfig.FetchObject(DbHelper); _attrList = SUrlAttribute.FetchObject(DbHelper); _suList = SUrl.FetchObject(DbHelper); SUrl.buildAttribute(_suList, _attrList); updateUi(); }); productThread.Start(); }
private void queryNum() { keyStr = this.queryTextBox.Text.ToString().Trim(); try { //string sql = "select e.CONSIGNEE AS '姓名',e.CANSIGNPHONE AS '电话',f.ASSOCIATOR_CARDNUMBER AS '卡号',e.ORDERNUM as '订单号',e.ORDERAMOUNT as '金额'" string sql = "select e.ORDERNUM ,e.ORDERAMOUNT,e.CONSIGNEE,e.CANSIGNPHONE,f.ASSOCIATOR_CARDNUMBER " + " From zc_order_history e " + " LEFT JOIN zc_associator_info f on e.member_id = f.id " + "where f.associator_cardnumber like '%" + keyStr + "%' " + "or e.consignee like '%" + keyStr + "%' " + "or e.cansignphone like '%" + keyStr + "%' "; //+ " WHERE e.UPDATETIME = '" + date_order + "'"; MysqlDBHelper dbHelper = new MysqlDBHelper(); DataSet ds = dbHelper.GetDataSet(sql, "zc_goods_master");; listDataGridView.DataSource = ds; listDataGridView.DataMember = "zc_goods_master"; } catch (Exception ex) { log.Error("加载数据源发生异常", ex); } }
private void HIQueryList_Load(object sender, EventArgs e) { idTextBox.Text = order_Num; nameTextBox.Text = order_Name; informTextBox.Text = order_Phone; cardTextBox.Text = order_Card; string sql = "select sum(nums) as nums,name,sum(g_price*nums) as totalprice,classify_name,goods_unit,delFlag,goods_specifications,serialNumber,g_price as actualnums,goodsfile_id,goods_class_id,g_price,orderNum from " + " (select a.goods_state,a.name,a.nums,b.goods_specifications,b.goods_unit,a.g_price,b.id as goodsfile_id,b.delFlag,b.serialNumber,c.classify_name,b.goods_class_id,b.goods_supplier_id,e.orderNum " + "from zc_order_history e " + "LEFT JOIN zc_associator_info f on e.member_id = f.id " + " LEFT JOIN zc_order_history_item a on e.id = a.order_id " + " left join zc_goods_master b on a.goodsfile_id = b.id " + " left join zc_classify_info c on b.goods_class_id = c.id " + " where e.orderNum='" + order_Num + "'" + " )as d group by name,delFlag,classify_name,goods_unit,goods_specifications,serialNumber,g_price,goodsfile_id,goods_class_id "; MysqlDBHelper dbHelper = new MysqlDBHelper(); DataSet ds = dbHelper.GetDataSet(sql, "zc_order_history"); listDataGridView.AutoGenerateColumns = false; listDataGridView.DataSource = ds; listDataGridView.DataMember = "zc_order_history"; }
/// <summary> /// 插入列定义 /// </summary> /// <param name="_table"></param> /// <param name="_tc"></param> public static void InsertColumnDefine(MD_Table _table, MD_TableColumn _tc) { try { StringBuilder _sb_insert = new StringBuilder(); _sb_insert.Append(" insert into md_tablecolumn (TCID,TID,COLUMNNAME,"); _sb_insert.Append(" ISNULLABLE,TYPE,`PRECISION`,SCALE,"); _sb_insert.Append(" LENGTH,REFDMB,DMBLEVELFORMAT,SECRETLEVEL,"); _sb_insert.Append(" DISPLAYTITLE,DISPLAYFORMAT,DISPLAYLENGTH,DISPLAYHEIGHT,"); _sb_insert.Append(" DISPLAYORDER,CANDISPLAY,COLWIDTH,DWDM,"); _sb_insert.Append(" CTAG,REFWORDTB ) values "); _sb_insert.Append(" (@TCID,@TID,@COLUMNNAME,"); _sb_insert.Append(" @ISNULLABLE,@TYPE,@PRECISION,@SCALE,"); _sb_insert.Append(" @LENGTH,@REFDMB,@DMBLEVELFORMAT,@SECRETLEVEL,"); _sb_insert.Append(" @DISPLAYTITLE,@DISPLAYFORMAT,@DISPLAYLENGTH,@DISPLAYHEIGHT,"); _sb_insert.Append(" @DISPLAYORDER,@CANDISPLAY,@COLWIDTH,@DWDM,"); _sb_insert.Append(" @CTAG,@REFWORDTB) "); MySqlParameter[] _param3 = { new MySqlParameter("@TCID", MySqlDbType.Int64), new MySqlParameter("@TID", MySqlDbType.Int64), new MySqlParameter("@COLUMNNAME", MySqlDbType.VarChar, 50), new MySqlParameter("@ISNULLABLE", MySqlDbType.VarChar, 100), new MySqlParameter("@TYPE", MySqlDbType.VarChar, 20), new MySqlParameter("@PRECISION", MySqlDbType.Int32), new MySqlParameter("@SCALE", MySqlDbType.Int32), new MySqlParameter("@LENGTH", MySqlDbType.Int32), new MySqlParameter("@REFDMB", MySqlDbType.VarChar, 50), new MySqlParameter("@DMBLEVELFORMAT", MySqlDbType.VarChar, 20), new MySqlParameter("@SECRETLEVEL", MySqlDbType.Int32), new MySqlParameter("@DISPLAYTITLE", MySqlDbType.VarChar, 50), new MySqlParameter("@DISPLAYFORMAT", MySqlDbType.VarChar, 50), new MySqlParameter("@DISPLAYLENGTH", MySqlDbType.Int32), new MySqlParameter("@DISPLAYHEIGHT", MySqlDbType.Int32), new MySqlParameter("@DISPLAYORDER", MySqlDbType.Int32), new MySqlParameter("@CANDISPLAY", MySqlDbType.Int32), new MySqlParameter("@COLWIDTH", MySqlDbType.Int32), new MySqlParameter("@DWDM", MySqlDbType.VarChar, 20), new MySqlParameter("@CTAG", MySqlDbType.VarChar, 500), new MySqlParameter("@REFWORDTB", MySqlDbType.VarChar, 50) }; _param3[0].Value = Convert.ToInt64(_tc.ColumnID); _param3[1].Value = Convert.ToInt64(_table.TID); _param3[2].Value = _tc.ColumnName; _param3[3].Value = _tc.IsNullable ? "Y" : "N"; _param3[4].Value = _tc.ColumnType; _param3[5].Value = Convert.ToInt32(_tc.Precision); _param3[6].Value = Convert.ToInt32(_tc.Scale); _param3[7].Value = Convert.ToInt32(_tc.Length); _param3[8].Value = _tc.RefDMB; _param3[9].Value = _tc.DMBLevelFormat; _param3[10].Value = Convert.ToInt32(_tc.SecretLevel); _param3[11].Value = _tc.DisplayTitle; _param3[12].Value = _tc.DisplayFormat; _param3[13].Value = Convert.ToInt32(_tc.DisplayLength); _param3[14].Value = Convert.ToInt32(_tc.DisplayHeight); _param3[15].Value = Convert.ToInt32(_tc.DisplayOrder); _param3[16].Value = _tc.CanDisplay ? 1 : 0; _param3[17].Value = Convert.ToInt32(_tc.ColWidth); _param3[18].Value = _tc.DWDM; _param3[19].Value = _tc.CTag; _param3[20].Value = _tc.RefWordTableName; MysqlDBHelper.ExecuteNonQuery(MysqlDBHelper.conf, CommandType.Text, _sb_insert.ToString(), _param3); } catch (Exception ex) { Debug.WriteLine(ex.Message); Debug.WriteLine(ex.StackTrace); } MyDA_MetaDataQuery.ModelLib.Clear(); }
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); } } } }
/// <summary> /// 查询条码匹配的记录 /// </summary> /// <param name="bar">条码</param> /// <returns>商品匹配的记录数</returns> public int queryExistGood(ILog log) { int con = 0; ZcGoodsMaster zcGoodsMaster = new ZcGoodsMaster(); MysqlDBHelper dbHelper = new MysqlDBHelper(); MySqlConnection conn = dbHelper.GetConnection(); try { string sql = "select a.SERIALNUMBER ,a.goods_name,a.goods_unit,a.goods_specifications,a.goods_price,a.remark,a.id from zc_goods_master a " + "left join zc_classify_info b on a.goods_class_id = b.id " + "left join zc_classify_info c on a.goods_brand_id = c.id " + "left join zc_provider_info d on a.goods_supplier_id = d.id where 1=1 "; if (this.count.Equals(ParentWindow.CustomerDelivery.ToString()) || this.count.Equals(ParentWindow.DeliveryGoods.ToString())) { sql += " and a.SERIALNUMBER like '%" + bar + "%'"; } else { sql += " and a.SERIALNUMBER like '%" + bar + "%' or a.goods_name like '%" + bar + "%' or a.goods_unit like '%" + bar + "%' or a.goods_specifications like '%" + bar + "%' or a.goods_price like '%" + bar + "%' or a.remark like '%" + bar + "%' ;"; } MySqlDataReader reader = dbHelper.GetReader(sql, conn); while (reader.Read()) { con += 1; if (con == 1) { zcGoodsMaster.SerialNumber = reader.IsDBNull(0) ? string.Empty : reader.GetString(0); zcGoodsMaster.GoodsName = reader.IsDBNull(1) ? string.Empty : reader.GetString(1); zcGoodsMaster.GoodsUnit = reader.IsDBNull(2) ? string.Empty : reader.GetString(2); zcGoodsMaster.GoodsSpecifications = reader.IsDBNull(3) ? string.Empty : reader.GetString(3); zcGoodsMaster.GoodsPrice = reader.IsDBNull(4) ? default(float) : reader.GetFloat(4); zcGoodsMaster.Remark = reader.IsDBNull(5) ? string.Empty : reader.GetString(5); zcGoodsMaster.Id = reader.IsDBNull(6) ? string.Empty : reader.GetString(6); } } if (con == 1) { if (num.Equals("")) { num = "1"; } if (this.count.Equals(ParentWindow.DeliveryGoods.ToString())) { this.deliveryGoods.AddGoods(zcGoodsMaster, num); } else if (this.count.Equals(ParentWindow.ReturnGoods.ToString())) { this.returnGoods.AddGoods(zcGoodsMaster, num); } else if (this.count.Equals(ParentWindow.CustomerDelivery.ToString())) { this.customerDelivery.AddGoods(zcGoodsMaster, num); } } } catch (Exception ex) { log.Error("选择扫描商品绑定数据发生异常", ex); } finally { dbHelper.CloseConnection(conn); } return(con); }
/// <summary> /// 更新列定义 /// </summary> /// <param name="_table"></param> /// <param name="_tc"></param> public static void UpdateColumnDefine(MD_Table _table, MD_TableColumn _tc) { StringBuilder _sb = new StringBuilder(); _sb.Append(" update md_tablecolumn set TID=@TID,COLUMNNAME=@COLUMNNAME,"); _sb.Append(" ISNULLABLE=@ISNULLABLE,TYPE=@TYPE,`PRECISION`=@PRECISION,SCALE=@SCALE,"); _sb.Append(" LENGTH=@LENGTH,REFDMB=@REFDMB,DMBLEVELFORMAT=@DMBLEVELFORMAT,SECRETLEVEL=@SECRETLEVEL,"); _sb.Append(" DISPLAYTITLE=@DISPLAYTITLE,DISPLAYFORMAT=@DISPLAYFORMAT,DISPLAYLENGTH=@DISPLAYLENGTH,DISPLAYHEIGHT=@DISPLAYHEIGHT,"); _sb.Append(" DISPLAYORDER=@DISPLAYORDER,CANDISPLAY=@CANDISPLAY,COLWIDTH=@COLWIDTH,DWDM=@DWDM,"); _sb.Append(" CTAG=@CTAG,REFWORDTB=@REFWORD "); _sb.Append(" WHERE TCID=@TCID"); MySqlParameter[] _param3 = { new MySqlParameter("@TID", MySqlDbType.Int64), new MySqlParameter("@COLUMNNAME", MySqlDbType.VarChar, 50), new MySqlParameter("@ISNULLABLE", MySqlDbType.VarChar, 100), new MySqlParameter("@TYPE", MySqlDbType.VarChar, 20), new MySqlParameter("@PRECISION", MySqlDbType.Int32), new MySqlParameter("@SCALE", MySqlDbType.Int32), new MySqlParameter("@LENGTH", MySqlDbType.Int32), new MySqlParameter("@REFDMB", MySqlDbType.VarChar, 50), new MySqlParameter("@DMBLEVELFORMAT", MySqlDbType.VarChar, 20), new MySqlParameter("@SECRETLEVEL", MySqlDbType.Int32), new MySqlParameter("@DISPLAYTITLE", MySqlDbType.VarChar, 50), new MySqlParameter("@DISPLAYFORMAT", MySqlDbType.VarChar, 50), new MySqlParameter("@DISPLAYLENGTH", MySqlDbType.Int32), new MySqlParameter("@DISPLAYHEIGHT", MySqlDbType.Int32), new MySqlParameter("@DISPLAYORDER", MySqlDbType.Int32), new MySqlParameter("@CANDISPLAY", MySqlDbType.Int32), new MySqlParameter("@COLWIDTH", MySqlDbType.Int32), new MySqlParameter("@DWDM", MySqlDbType.VarChar, 20), new MySqlParameter("@CTAG", MySqlDbType.VarChar, 500), new MySqlParameter("@REFWORD", MySqlDbType.VarChar, 50), new MySqlParameter("@TCID", MySqlDbType.Int64) }; _param3[0].Value = Convert.ToInt64(_table.TID); _param3[1].Value = _tc.ColumnName; _param3[2].Value = _tc.IsNullable ? "Y" : "N"; _param3[3].Value = _tc.ColumnType; _param3[4].Value = Convert.ToInt32(_tc.Precision); _param3[5].Value = Convert.ToInt32(_tc.Scale); _param3[6].Value = Convert.ToInt32(_tc.Length); _param3[7].Value = _tc.RefDMB; _param3[8].Value = _tc.DMBLevelFormat; _param3[9].Value = Convert.ToInt32(_tc.SecretLevel); _param3[10].Value = _tc.DisplayTitle; _param3[11].Value = _tc.DisplayFormat; _param3[12].Value = Convert.ToInt32(_tc.DisplayLength); _param3[13].Value = Convert.ToInt32(_tc.DisplayHeight); _param3[14].Value = Convert.ToInt32(_tc.DisplayOrder); _param3[15].Value = _tc.CanDisplay ? 1 : 0; _param3[16].Value = Convert.ToInt32(_tc.ColWidth); _param3[17].Value = _tc.DWDM; _param3[18].Value = _tc.CTag; _param3[19].Value = _tc.RefWordTableName; _param3[20].Value = Convert.ToInt64(_tc.ColumnID); MysqlDBHelper.ExecuteNonQuery(MysqlDBHelper.conf, CommandType.Text, _sb.ToString(), _param3); MyDA_MetaDataQuery.ModelLib.Clear(); }