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