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