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