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