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