public bool panDuanChongQiByUpdate(string pcname, string[] pcnames) { SqlHelp sqh = SqlHelp.GetInstance(); lock (obj) { try { int r = 0; for (int i = 0; i < pcnames.Length; i++) { if (pcname.ToUpper().Equals(pcnames[i].ToUpper())) { r = i; } } int r1 = 0; string sqlsel = "select xh,pcxiugai from jiankong where xh in( select max(xh) zd from jiankong)"; DataTable dt = sqh.getAll(sqlsel); if (dt.Rows.Count > 0) { string quan = (string)dt.Rows[0][1]; string[] quanzu = quan.Split('|'); r1 = int.Parse(quanzu[r]); WriteLog.WriteLogFile("", "r1:" + r1); } int r2 = -1; sqlsel = "select xh,pcxiugai from jiankong where xh in( select max(xh)-1 zd from jiankong)"; dt = sqh.getAll(sqlsel); if (dt.Rows.Count > 0) { string quan = (string)dt.Rows[0][1]; string[] quanzu = quan.Split('|'); r2 = int.Parse(quanzu[r]); WriteLog.WriteLogFile("", "r2:" + r2); } if (r1 == r2) { return(true); } return(false); } catch (Exception ex) { throw ex; } } }
/// <summary> /// 得到运行情况 /// </summary> /// <param name="youxi"></param> public List <YunXingQK> getYunXingQk() { //得到运行情况后存入表 WriteLog.WriteLogFile("", "得到运行情况后显示在前台"); SqlHelp sqh = SqlHelp.GetInstance(); List <YunXingQK> rs = new List <YunXingQK>(); try { string selsql = "select top 10 a.* from yunxingqk a order by a.xh desc"; DataTable dt = sqh.getAll(selsql); int a = dt.Rows.Count; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { YunXingQK jqqk = new YunXingQK(); jqqk.Xh = (int)dt.Rows[i][0]; Dictionary <string, JiQiYunXing> dict = new Dictionary <string, JiQiYunXing>(); JiQiYunXing jq1 = new JiQiYunXing(); jqqk.Zongxiugai = (int)dt.Rows[i][1]; jq1.Chuchan = (int)dt.Rows[i][2]; dict.Add("hao1", jq1); JiQiYunXing jq2 = new JiQiYunXing(); jq2.Xiugai = (int)dt.Rows[i][3]; jq2.Chuchan = (int)dt.Rows[i][4]; dict.Add("hao2", jq2); JiQiYunXing jq3 = new JiQiYunXing(); jq3.Xiugai = (int)dt.Rows[i][5]; jq3.Chuchan = (int)dt.Rows[i][6]; dict.Add("hao3", jq3); JiQiYunXing zk = new JiQiYunXing(); zk.Xiugai = (int)dt.Rows[i][7]; zk.Chuchan = (int)dt.Rows[i][8]; dict.Add("zk", zk); jqqk.Jqyx = dict; jqqk.Xgsj = (DateTime)dt.Rows[i][13]; rs.Add(jqqk); } } } catch (Exception ex) { WriteLog.WriteLogFile("", "得到运行情况失败"); throw ex; } return(rs); }
public void zhiweiwuxiao(int dqinx, string youxi, string name, string pcname) { //服务器上有登录账号后置为登陆中 SqlHelp sqh = SqlHelp.GetInstance(); lock (obj) { try { sqh.update("update zhanghao set yxbz='N' where name='" + name + "' and youxi='" + youxi + "'"); } catch (Exception ex) { WriteLog.WriteLogFile(dqinx + "", "更新账号为无效失败"); throw ex; } } }
public void gengxinjieduan(int dqinx, string youxi, string name, string jieduan = "zhuxian") { //服务器上有登录账号后置为登陆中 SqlHelp sqh = SqlHelp.GetInstance(); lock (obj) { try { sqh.update("update zhanghao set jieduan='" + jieduan + "' where name='" + name + "' and youxi='" + youxi + "'"); } catch (Exception ex) { WriteLog.WriteLogFile(dqinx + "", "更新账号的阶段是zhuxian还是denglu,更新失败"); throw ex; } } }
public void updateYiMai(string youxi, string name) { //服务器上有登录账号后置为登陆中 SqlHelp sqh = SqlHelp.GetInstance(); lock (obj) { try { sqh.update("update zhanghao with (UPDLOCK) set yimai='Y' where name='" + name + "' and youxi='" + youxi + "'"); } catch (Exception ex) { WriteLog.WriteLogFile("", "更新账号的已卖标志,更新失败" + ex.Message); throw ex; } } }
public void zhiweidengluzhongN(int dqinx, string youxi, string name, string pcname) { //服务器上有登录账号后置为登陆中 SqlHelp sqh = SqlHelp.GetInstance(); lock (obj) { try { string dqsj = DateTime.Now.ToString("yyyy-MM-dd"); sqh.update("update zhanghao set dengluzhong='N',xgsj='" + dqsj + "',dqindex=" + dqinx + " where name='" + name + "' and youxi='" + youxi + "'"); } catch (Exception ex) { WriteLog.WriteLogFile("", "所有账号置为N更新失败"); throw ex; } } }
public void zhiweidengluzhong(int dqinx, string youxi, string name) { //服务器上有登录账号后置为登陆中 SqlHelp sqh = SqlHelp.GetInstance(); WriteLog.WriteLogFile(dqinx + "", "置为登陆中" + name); lock (obj) { try { sqh.update("update zhanghao set dengluzhong='Y' where name='" + name + "' and youxi='" + youxi + "'"); } catch (Exception ex) { WriteLog.WriteLogFile(dqinx + "", "更新登录中账号失败"); throw ex; } } }
public void saveipfirst(int dqinx, string ip, out bool yiyong) { SqlHelp sqh = SqlHelp.GetInstance(); DataTable dt = sqh.getAll("select shiyong from ipqk where rq='" + DateTime.Now.ToString("yyyy-MM-dd") + "'and ip='" + ip + "'"); yiyong = false; if (dt.Rows.Count > 0) { yiyong = true; int ox = (int)dt.Rows[0][0]; WriteLog.WriteLogFile(dqinx + "", "这个ip今天已经用过" + ip + "," + ox + "次,又碰到了"); lock (obj) { try { sqh.update("update ipqk set shiyong=" + (ox + 1) + " where ip='" + ip + "' and rq='" + DateTime.Now.ToString("yyyy-MM-dd") + "'"); } catch (Exception ex) { throw ex; } } } else { lock (obj) { try { sqh.update("insert into ipqk (rq,pcname,ip,shiyong) values(" + "'" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + WriteLog.getMachineName() + "','" + ip + "'," + 1 + " )"); } catch (Exception ex) { throw ex; } } } }
/* * USE [yiquan] * GO * SET ANSI_NULLS ON * GO * SET QUOTED_IDENTIFIER ON * GO * SET ANSI_PADDING ON * GO * CREATE TABLE [dbo].[zhanghao]( * [name] [varchar](50) NULL, * [pwd] [varchar](50) NULL, * [yxbz] [char](1) NULL, * [dengluzhong] [char](1) NULL, * [dqindex] [int] NULL, * [pcname] [varchar](50) NULL, * [img] [varchar](50) NULL, * [imgtime] [date] NULL, * [daydenglu] [text] NULL, * [yimai] [char](1) NULL * ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] * * GO * * SET ANSI_PADDING OFF * GO */ /// <summary> /// 单例模式====双层互锁 /// </summary> /// <returns></returns> public static SqlHelp GetInstance() { if (mysql == null) { lock (obj) { mysql = new SqlHelp(); string connString = null; if (WriteLog.getMachineName().ToLower().Equals("wlzhongkong") || WriteLog.getMachineName().ToLower().Equals("wlbgs")) { connString = "Data Source=" + WriteLog.getMachineName().ToLower() + @"\SQLEXPRESS;Initial Catalog=yiquan;User ID=sa;Password=123456"; } else { connString = @"Data Source=192.168.4.44;Initial Catalog=yiquan;User ID=sa;Password=123456"; } conn = new SqlConnection(connString); } } return(mysql); }
public DateTime getYunXingUpdateLasttime() { SqlHelp sqh = SqlHelp.GetInstance(); lock (obj) { try { DataTable dt = sqh.getAll("select max(gxsj) from jiankong "); if (dt.Rows.Count > 0) { return((DateTime)dt.Rows[0][0]); } return(DateTime.MaxValue); } catch (Exception ex) { throw ex; } } }
/// <summary> /// 得到导出情况 /// </summary> /// <param name="youxi"></param> public List <string> getDaoChuShuLiang(string youxi, int shuliang = 0, int zuanshi = -1, int qiangzhequan = -1) { //得到运行情况后存入表 WriteLog.WriteLogFile("", "得到导出数量"); SqlHelp sqh = SqlHelp.GetInstance(); List <string> rs = new List <string>(); try { string selsql = ""; if (zuanshi > 0 && qiangzhequan > 0) { selsql = "select name from zhanghao where yxbz='Y' and yimai='N' and youxi='" + youxi + "' and zuanshi>" + zuanshi + "and qiangzhequan>" + qiangzhequan; } else { selsql = "select name from zhanghao where yxbz='Y' and yimai='N' and youxi='" + youxi + "'"; } if (shuliang > 0) { selsql = "select top " + shuliang + selsql.Substring(6); } DataTable dt = sqh.getAll(selsql); int a = dt.Rows.Count; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { rs.Add((string)dt.Rows[i][0]); } } } catch (Exception ex) { WriteLog.WriteLogFile("", "得到要导出的账号失败"); throw ex; } return(rs); }
public void updateIp(int dqinx, string youxi, string name, string ip) { //服务器上有登录账号后置为登陆中 SqlHelp sqh = SqlHelp.GetInstance(); lock (obj) { if (ip.Trim().Length > 20) { ip = ip.Trim().Substring(0, 20); } try { sqh.update("update zhanghao set ip='" + ip + "' where name='" + name + "' and youxi='" + youxi + "'"); } catch (Exception ex) { WriteLog.WriteLogFile(dqinx + "", "更新账号的ip,更新失败" + ex.Message); throw ex; } } }
public void updateXuanqu(string name, int xuanqu) { SqlHelp sqh = SqlHelp.GetInstance(); lock (obj) { try { DataTable dt = sqh.getAll("select top 1 name from zhanghao where name = '" + name + "'"); if (dt.Rows.Count > 0) { sqh.update("update zhanghao set dengluzhong='Y'," + "xuanqu=" + xuanqu + " where name='" + name + "'"); } } catch (Exception ex) { throw ex; } } }
/// <summary> /// 更新运行情况表 /// </summary> /// <param name="youxi"></param> public void gxYunXingQk() { //得到运行情况后存入表 WriteLog.WriteLogFile("", "得到运行情况后存入表"); SqlHelp sqh = SqlHelp.GetInstance(); lock (obj) { try { YunXingQK jqqk = new YunXingQK(); string selsql = "select " + "sum(case when z.pcname='1hao' and z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) hao1chanshu," + "sum(case when z.pcname='2hao' and z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) hao2xiugai," + "sum(case when z.pcname='2hao' and z.zuanshi>0 and z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) hao2chanshu," + "sum(case when z.pcname='3hao' and z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) hao3xiugai," + "sum(case when z.pcname='3hao' and z.zuanshi>0 and z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) hao2chanshu," + "sum(case when z.pcname='wlzhongkong' and z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) zkxiugai," + "sum(case when z.pcname='wlzhongkong' and z.zuanshi>0 and z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) zkchanshu," + "sum(case when z.zuanshi>0 then 1 else 0 end) zuanshidayu0," + "sum(case when z.zuanshi>1000 then 1 else 0 end) zuanshidayu1000," + "sum(case when z.zuanshi>3000 then 1 else 0 end) zuanshidayu3000," + "sum(case when z.qiangzhequan>0 then 1 else 0 end) qiangzhedayu0," + "sum(case when z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) zxiugai" + " from zhanghao z where yxbz='Y' and yimai='N'"; DataTable dt = sqh.getAll(selsql); int a = dt.Rows.Count; if (dt.Rows.Count > 0) { Dictionary <string, JiQiYunXing> dict = new Dictionary <string, JiQiYunXing>(); JiQiYunXing jq1 = new JiQiYunXing(); jq1.Chuchan = (int)dt.Rows[0][0]; dict.Add("hao1", jq1); JiQiYunXing jq2 = new JiQiYunXing(); jq2.Xiugai = (int)dt.Rows[0][1]; jq2.Chuchan = (int)dt.Rows[0][2]; dict.Add("hao2", jq2); JiQiYunXing jq3 = new JiQiYunXing(); jq3.Xiugai = (int)dt.Rows[0][3]; jq3.Chuchan = (int)dt.Rows[0][4]; dict.Add("hao3", jq3); JiQiYunXing zk = new JiQiYunXing(); zk.Xiugai = (int)dt.Rows[0][5]; zk.Chuchan = (int)dt.Rows[0][6]; dict.Add("zk", zk); jqqk.Jqyx = dict; jqqk.Zuanshidayu0 = (int)dt.Rows[0][7]; jqqk.Zuanshidayu1000 = (int)dt.Rows[0][8]; jqqk.Zuanshidayu3000 = (int)dt.Rows[0][9]; jqqk.Qiangzhedayu0 = (int)dt.Rows[0][10]; jqqk.Xgsj = DateTime.Now; jqqk.Zongxiugai = (int)dt.Rows[0][11]; WriteLog.WriteLogFile("", "当前运行机器的出产情况" + jqqk.Zongxiugai + "单独:" + jqqk.Jqyx["hao1"].Chuchan + " " + jqqk.Jqyx["hao2"].Chuchan + " " + jqqk.Jqyx["hao3"].Chuchan + " " + jqqk.Jqyx["zk"].Chuchan); } string inssql = "insert into yunxingqk (hao1chanchu,hao2xiugai,hao2chanchu,hao3xiugai,hao3chanchu,zkxiugai,zkchanchu,zuanshidayu0,zuanshidayu1000,zuanshidayu3000,qiangzhedayu0,gxsj,zxiugai) values(" + jqqk.Jqyx["hao1"].Chuchan + "," + jqqk.Jqyx["hao2"].Xiugai + "," + jqqk.Jqyx["hao2"].Chuchan + "," + jqqk.Jqyx["hao3"].Xiugai + "," + jqqk.Jqyx["hao3"].Chuchan + "," + jqqk.Jqyx["zk"].Xiugai + "," + jqqk.Jqyx["zk"].Chuchan + "," + jqqk.Zuanshidayu0 + "," + jqqk.Zuanshidayu1000 + "," + jqqk.Zuanshidayu3000 + "," + jqqk.Qiangzhedayu0 + ",'" + jqqk.Xgsj + "'," + jqqk.Zongxiugai + ")"; sqh.update(inssql); } catch (Exception ex) { WriteLog.WriteLogFile("", "更新运行情况失败"); throw ex; } } }
public List <ZhangHaoEntity> getZhangHaoListShuLiang(string youxi, int shuliang = 0, int zuanshi = -1, int qiangzhequan = -1) { SqlHelp sqh = SqlHelp.GetInstance(); string dqsj = DateTime.Now.ToString("yyyy-MM-dd"); List <ZhangHaoEntity> rs = new List <ZhangHaoEntity>(); lock (obj) { string selsql1 = ""; if (zuanshi > 0 && qiangzhequan > 0) { selsql1 = "select name from zhanghao where yxbz='Y' and yimai='N' and youxi='" + youxi + "' and zuanshi>" + zuanshi + "and qiangzhequan>" + qiangzhequan; } else { selsql1 = "select name from zhanghao where yxbz='Y' and yimai='N' and youxi='" + youxi + "'"; } if (shuliang > 0) { selsql1 = "select top " + shuliang + selsql1.Substring(6); } string updatesql = "update zhanghao with (UPDLOCK) set yxbz='N',yimai='Y' " + " where name in ( " + selsql1 + " )"; sqh.update(updatesql); string selsql = ""; if (zuanshi > 0 && qiangzhequan > 0) { selsql = "select name,pwd,isnull(xuanqu,-1),isnull(zuanshi,-1),isnull(qiangzhequan,-1) from zhanghao where yxbz='N' and yimai='Y' and youxi='" + youxi + "' and zuanshi>" + zuanshi + "and qiangzhequan>" + qiangzhequan; } else { selsql = "select name,pwd,isnull(xuanqu,-1),isnull(zuanshi,-1),isnull(qiangzhequan,-1) from zhanghao where yxbz='N' and yimai='Y' and youxi='" + youxi + "'"; } string selcha = selsql; if (shuliang > 0) { selcha = "select top " + shuliang + selsql.Substring(6); } DataTable dt = sqh.getAll(selcha); if (dt.Rows.Count > 0) { //name,pwd,isnull(xuanqu,-1),yimai,yxbz,isnull(zuanshi,-1),isnull(qiangzhe,-1),pcname,xgsj foreach (DataRow r in dt.Rows) { ZhangHaoEntity zhe = new ZhangHaoEntity(); zhe.Name = (string)r[0]; zhe.Pwd = (string)r[1]; zhe.Xuanqu = (int)r[2]; zhe.Zuanshi = (int)r[3]; zhe.Qiangzhe = (int)r[4]; zhe.Youxi = youxi; rs.Add(zhe); //WriteLog.WriteLogFile("", "找到需要练级的账号" + name + " " + pwd + ",xuanqu " + xuanqu + "并置为登录中"); } } if (zuanshi > 0 && qiangzhequan > 0) { selsql = "select name from zhanghao where yxbz='N' and yimai='Y' and youxi='" + youxi + "' and zuanshi>" + zuanshi + "and qiangzhequan>" + qiangzhequan; } else { selsql = "select name from zhanghao where yxbz='N' and yimai='Y' and youxi='" + youxi + "'"; } selcha = selsql; if (shuliang > 0) { selcha = "select top " + shuliang + " name " + selcha.Substring(6); } updatesql = "update zhanghao with (UPDLOCK) set yxbz='Y' " + " where name in ( " + selcha + " )"; sqh.update(updatesql); } return(rs); }