public void zhunbeizhanghao(int dqinx, string youxi, out string name, out string pwd, out int xuanqu, out int dengji, out string jieduan) { //服务器上有应该登录的账号则使用指定账号登录 WriteLog.WriteLogFile(dqinx + "", "开始找需要练级的账号"); name = ""; pwd = null; xuanqu = -1; dengji = -1; jieduan = ""; SqlHelp sqh = SqlHelp.GetInstance(); string dqsj = DateTime.Now.ToString("yyyy-MM-dd"); lock (obj) { DataTable dt = sqh.getAll("select top 1 name,pwd,isnull(xuanqu,-1),isnull(dengji,-1),isnull(jieduan,'') from zhanghao where yxbz='Y' and yimai='N' and dengluzhong='Y' and pcname='" + WriteLog.getMachineName() + "' and dqindex=" + dqinx + " and youxi='" + youxi + "' order by xuanqu desc") ; if (dt.Rows.Count > 0) { name = (string)dt.Rows[0][0]; pwd = (string)dt.Rows[0][1]; xuanqu = (int)dt.Rows[0][2]; dengji = (int)dt.Rows[0][3]; jieduan = (string)dt.Rows[0][4]; WriteLog.WriteLogFile(dqinx + "", "找到需要练级的账号" + name + " " + pwd + ",xuanqu " + xuanqu + "并置为登录中"); return; } string updatesql = "update zhanghao with (UPDLOCK) set dengluzhong='Y',pcname='" + WriteLog.getMachineName() + "', dqindex=" + dqinx + " where name=(select top 1 name from zhanghao " + " where xgsj < '" + dqsj + "' and yxbz='Y' and dengluzhong='N' " + " and yimai='N' and youxi='" + youxi + "' order by xuanqu desc)"; sqh.update(updatesql); dt = sqh.getAll("select top 1 name,pwd,isnull(xuanqu,-1),isnull(dengji,-1),isnull(jieduan,'') from zhanghao where yxbz='Y' and yimai='N' and dengluzhong='Y' and pcname='" + WriteLog.getMachineName() + "' and dqindex=" + dqinx + " and youxi='" + youxi + "'") ; if (dt.Rows.Count > 0) { name = (string)dt.Rows[0][0]; pwd = (string)dt.Rows[0][1]; xuanqu = (int)dt.Rows[0][2]; dengji = (int)dt.Rows[0][3]; jieduan = (string)dt.Rows[0][4]; WriteLog.WriteLogFile(dqinx + "", "找到需要练级的账号" + name + " " + pwd + ",xuanqu " + xuanqu + "并置为登录中"); } } }
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; } } }
public void lurenSaveNameAndPas(string name, string pwd, int dqindex, string youxi = "jingjie") { SqlHelp sqh = SqlHelp.GetInstance(); DataTable dt = sqh.getAll("select top 1 name from zhanghao where name = '" + name + "' and youxi='" + youxi + "'"); if (dt.Rows.Count > 0) { WriteLog.WriteLogFile(dqindex + "", "当前游戏 " + youxi + " 已存在这个账号" + name); return; } lock (obj) { try { sqh.update("insert into zhanghao (name,pwd,dqindex,yxbz,yimai,dengluzhong,pcname,xgsj,youxi,xuanqu) values('" + name + "','" + pwd + "'," + dqindex + ",'Y','N','N','" + WriteLog.getMachineName() + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + youxi + "',1)"); } catch (Exception ex) { throw ex; } } }
public void denglusaveNameAndPas(string name, string pwd, int dqindex, string youxiname) { SqlHelp sqh = SqlHelp.GetInstance(); lock (obj) { try { DataTable dt = sqh.getAll("select top 1 name from zhanghao where name = '" + name + "' and youxi='" + youxiname + "'"); if (dt.Rows.Count > 0) { sqh.update("update zhanghao set dengluzhong='Y' where name='" + name + "'"); } else { sqh.update("insert into zhanghao (name,pwd,dqindex,yxbz,yimai,dengluzhong,pcname,xgsj,youxi) values('" + name + "','" + pwd + "'," + dqindex + ",'Y','N','Y','" + WriteLog.getMachineName() + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + youxiname + "')"); } } catch (Exception ex) { throw ex; } } }
public Dictionary <string, string> getZhanghaoXinxiForDaochu(string youxi, string zhanghao) { //服务器上有登录账号后置为登陆中 SqlHelp sqh = SqlHelp.GetInstance(); Dictionary <string, string> rs = new Dictionary <string, string>(); try { DataTable dt = sqh.getAll("select zhanghao,pwd,youxi,isnull(zuanshi,-1),isnull(qiangzhequan,-1),isnull(xuanqu,-1) from zhanghao where name='" + zhanghao + "'and youxi='" + youxi + "' and yxbz='Y' and yimai='N'") ; if (dt.Rows.Count > 0) { rs.Add("youxi", youxi); rs.Add("zhanghao", zhanghao); rs.Add("pwd", (string)dt.Rows[0][2]); rs.Add("zuanshi", (int)dt.Rows[0][3] + ""); rs.Add("qiangzhequan", (int)dt.Rows[0][4] + ""); rs.Add("xuanqu", (int)dt.Rows[0][5] + ""); WriteLog.WriteLogFile("", "找到需要上架的账号" + zhanghao + " "); } } catch (Exception ex) { WriteLog.WriteLogFile("", "取得账号信息失败"); throw ex; } return(rs); }
/// <summary> /// 得到更新的运行情况 /// </summary> /// <param name="youxi"></param> public List <YunXingQK> getUpdateQk() { //得到运行情况后存入表 WriteLog.WriteLogFile("", "得到运行情况后显示在前台-update"); SqlHelp sqh = SqlHelp.GetInstance(); List <YunXingQK> rs = new List <YunXingQK>(); try { string selsql = "select top 72 a.* from jiankong 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]; jqqk.Zongxiugai = (int)dt.Rows[i][1]; jqqk.Pcall = (string)dt.Rows[i][2]; jqqk.Zuanshidayu0 = (int)dt.Rows[i][3]; jqqk.Qiangzhedayu0 = (int)dt.Rows[i][4]; jqqk.Xgsj = (DateTime)dt.Rows[i][5]; rs.Add(jqqk); } } } catch (Exception ex) { WriteLog.WriteLogFile("", "得到运行情况失败"); throw ex; } return(rs); }
/// <summary> /// 得到可卖情况 /// </summary> /// <param name="youxi"></param> public List <Object[]> getPcKeMai(string youxi) { //得到运行情况后存入表 WriteLog.WriteLogFile("", "得到运行情况后显示在前台-可卖"); SqlHelp sqh = SqlHelp.GetInstance(); List <Object[]> rs = new List <Object[]>(); try { string selsql = "select pcname,COUNT(name) from zhanghao where yxbz='Y' and yimai='N' and youxi='" + youxi + "' group by pcname"; DataTable dt = sqh.getAll(selsql); int a = dt.Rows.Count; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Object[] obj = new Object[] { (string)dt.Rows[i][0], (int)dt.Rows[i][1] }; rs.Add(obj); } } } catch (Exception ex) { WriteLog.WriteLogFile("", "得到运行情况失败"); throw ex; } return(rs); }
public void getZhanghaoXinxi(int dqinx, string youxi, string zhanghao, string xinxi, out int ox) { //服务器上有登录账号后置为登陆中 SqlHelp sqh = SqlHelp.GetInstance(); ox = -1; WriteLog.WriteLogFile(dqinx + "", "取到账号" + zhanghao + "相关信息"); lock (obj) { try { DataTable dt = sqh.getAll("select isnull(" + xinxi + ",-1) from zhanghao where name='" + zhanghao + "'and youxi='" + youxi + "'") ; if (dt.Rows.Count > 0) { ox = (int)dt.Rows[0][0]; WriteLog.WriteLogFile(dqinx + "", "找到需要练级的账号" + zhanghao + " " + xinxi + ", " + ox); } } catch (Exception ex) { WriteLog.WriteLogFile(dqinx + "", "更新登录中账号失败"); throw ex; } } }
public bool panduanIpKeYong(int dqinx, string youxi, string ip) { //服务器上有登录账号后置为登陆中 SqlHelp sqh = SqlHelp.GetInstance(); lock (obj) { try { DataTable dt = sqh.getAll("select name,isnull(ip,'') from zhanghao where ip='" + ip + "' and youxi='" + youxi + "' and yxbz='Y' and dengluzhong='Y' and xgsj='" + DateTime.Now.ToString("yyyy-MM-dd") + "'") ; if (dt.Rows.Count > 0) { WriteLog.WriteLogFile(dqinx + "", "找到需要练级的账号" + dt.Rows[0][0] + " " + dt.Rows[0][1] + "为相同ip:" + ip); return(true); } } catch (Exception ex) { WriteLog.WriteLogFile(dqinx + "", "更新账号的ip,更新失败"); throw ex; } return(false); } }
public bool panDuanChongQi(string pcname) { SqlHelp sqh = SqlHelp.GetInstance(); lock (obj) { try { string pn = ""; switch (pcname) { case "1HAO": pn = "hao1chanchu"; break; case "2HAO": pn = "hao2xiugai"; break; case "3HAO": pn = "hao3xiugai"; break; case "WLZHONGKONG": pn = "zkxiugai"; break; default: break; } if (pn == null || pn.Equals("")) { return(false); } string sqlsel = "select a1.cc-a2.cc from (select xh," + pn + " cc from yunxingqk where xh in( " + "select max(xh) zd from yunxingqk)) a1,(select xh," + pn + " cc from yunxingqk " + " where xh in(select max(xh)-1 cd from yunxingqk)) a2"; DataTable dt = sqh.getAll(sqlsel); if (dt.Rows.Count > 0) { int a = (int)dt.Rows[0][0]; WriteLog.WriteLogFile("", "更新运行情况差异值 " + a); if (a == 0) { return(true); } } return(false); } catch (Exception ex) { throw ex; } } }
public int getJiuYouZhangHaoCount(int dqinx, string youxi = "jiuyouzhuce") { SqlHelp sqh = SqlHelp.GetInstance(); DataTable dt = sqh.getAll("select count(*) from zhanghao where youxi='" + youxi + "'"); int r = 0; if (dt.Rows.Count > 0) { r = (int)dt.Rows[0][0]; WriteLog.WriteLogFile(dqinx + "", "当前游戏 " + youxi + " 存在" + r + "个账号"); } return(r); }
/// <summary> /// 更新运行情况表 改善的运行情况 /// </summary> /// <param name="youxi"></param> public void updateYunXingQk(string[] pcnames) { //得到运行情况后存入表 WriteLog.WriteLogFile("", "得到运行情况后存入表"); SqlHelp sqh = SqlHelp.GetInstance(); lock (obj) { try { YunXingQK jqqk = new YunXingQK(); string selsql = "select "; foreach (string pc in pcnames) { selsql = selsql + "sum(case when z.pcname='" + pc + "' and z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) " + "a" + pc + ","; } selsql = selsql + "sum(case when z.zuanshi>0 and z.xgsj>=convert(varchar(10),getdate(),120) then z.zuanshi else 0 end) zuanshi," + "sum(case when z.qiangzhequan>0 and z.xgsj>=convert(varchar(10),getdate(),120) then z.qiangzhequan else 0 end) qiangzhe," + "sum(case when z.xgsj>=convert(varchar(10),getdate(),120) then 1 else 0 end) zxiugai from zhanghao z where yxbz='Y'"; DataTable dt = sqh.getAll(selsql); int a = dt.Rows.Count; StringBuilder pcyunxing = new StringBuilder(); if (dt.Rows.Count > 0) { for (int i = 0; i < pcnames.Length - 1; i++) { pcyunxing.Append(dt.Rows[0][i] + "|"); } pcyunxing.Append(dt.Rows[0][pcnames.Length - 1]); jqqk.Zuanshidayu0 = (int)dt.Rows[0][pcnames.Length]; jqqk.Qiangzhedayu0 = (int)dt.Rows[0][pcnames.Length + 1]; jqqk.Xgsj = DateTime.Now; jqqk.Zongxiugai = (int)dt.Rows[0][pcnames.Length + 2]; WriteLog.WriteLogFile("", "当前运行机器的出产情况" + pcyunxing.ToString()); } string inssql = "insert into jiankong (zxiugai,pcxiugai,zuanshidayu0,qiangzhedayu0,gxsj) values(" + jqqk.Zongxiugai + ",'" + pcyunxing.ToString() + "'," + jqqk.Zuanshidayu0 + "," + jqqk.Qiangzhedayu0 + ",'" + jqqk.Xgsj + "')"; sqh.update(inssql); } catch (Exception ex) { WriteLog.WriteLogFile("", "更新运行情况失败"); throw ex; } } }
public List <ZhangHaoEntity> getZhangHaoList(string youxi, string yimai = "", string yxbz = "", int xuanqu = -1, string pcname = "") { SqlHelp sqh = SqlHelp.GetInstance(); //string dqsj1 = DateTime.Now.ToString("yyyy-MM-dd"); List <ZhangHaoEntity> rs = new List <ZhangHaoEntity>(); lock (obj) { string sql = "select name,pwd,isnull(xuanqu,-1),yimai,yxbz,isnull(zuanshi,-1),isnull(qiangzhequan,-1),pcname,xgsj from zhanghao where youxi='" + youxi + "'"; if (yimai != null && !"".Equals(yimai)) { sql += " and yimai='" + yimai + "' "; } if (yxbz != null && !"".Equals(yxbz)) { sql += " and yxbz='" + yxbz + "' "; } if (yxbz != null && xuanqu != -1) { sql += " and xuanqu=" + xuanqu + " "; } if (pcname != null && !"".Equals(pcname)) { sql += " and pcname='" + pcname + "' "; } DataTable dt = sqh.getAll(sql); 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.Yimai = (string)r[3]; zhe.Yxbz = (string)r[4]; zhe.Zuanshi = (int)r[5]; zhe.Qiangzhe = (int)r[6]; zhe.Pcname = (string)r[7]; zhe.Xgsj = (DateTime)r[8]; zhe.Youxi = youxi; rs.Add(zhe); //WriteLog.WriteLogFile("", "找到需要练级的账号" + name + " " + pwd + ",xuanqu " + xuanqu + "并置为登录中"); } } } return(rs); }
public void tuichusaveNameAndPas(string name, int dqindex, string youxi, string pcname, int dengji, int zuanshi, int qiangzhequan) { WriteLog.WriteLogFile(dqindex + "", "name " + name + ",pcname " + pcname + ",强者券 " + qiangzhequan + ",钻石 " + zuanshi + ",等级 " + dengji); SqlHelp sqh = SqlHelp.GetInstance(); lock (obj) { try { DataTable dt = sqh.getAll("select top 1 name from zhanghao where name = '" + name + "' and youxi='" + youxi + "'"); if (dt.Rows.Count > 0) { if (dengji != -1 && zuanshi != -1 && qiangzhequan != -1) { sqh.update("update zhanghao set xgsj='" + DateTime.Now.ToString("yyyy-MM-dd") + "' , dengji=" + dengji + ", zuanshi =" + zuanshi + " , qiangzhequan=" + qiangzhequan + " , dengluzhong='N' " + " where name='" + name + "' and youxi='" + youxi + "'"); } else if (zuanshi != -1 && qiangzhequan == -1) { sqh.update("update zhanghao set xgsj='" + DateTime.Now.ToString("yyyy-MM-dd") + "', zuanshi =" + zuanshi + " , dengluzhong='N' " + " where name='" + name + "' and youxi='" + youxi + "'"); } else if (zuanshi != -1 && qiangzhequan != -1) { sqh.update("update zhanghao set xgsj='" + DateTime.Now.ToString("yyyy-MM-dd") + "', zuanshi =" + zuanshi + " , qiangzhequan=" + qiangzhequan + " , dengluzhong='N' " + " where name='" + name + "' and youxi='" + youxi + "'"); } else { sqh.update("update zhanghao set xgsj='" + DateTime.Now.ToString("yyyy-MM-dd") + "', dengluzhong='N' " + " where name='" + name + "' and youxi='" + youxi + "'"); } } else { WriteLog.WriteLogFile(dqindex + "", "退出时更新失败,没有找到登陆中账号"); } } 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 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; } } } }
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 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); }