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