//查出当前打卡用户的id
public DataTable Select8(DateTime a)
{
string s = "select * from attendance where date='" + a + "'";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select3(string str)
{
string s = "SELECT sx from test WHERE parentId2 in ( SELECT parentId2 from test where parentId ='" + str + "')";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select5(string a, string b)
{
string s = "select id from test where pId ='" + a + "' and sx ='" + b + "'";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select114(string a, string b)
{
string s = "select iszl from zl where lzId='" + a + "'and bh='" + b + "'";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable select112(string str, string c)
{
string s = "select id,sx,zId from test where pId = '" + str + "' and zId >= 11 and zId <= 18 and lzId='" + c + "' ";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select11(string a, string b, string c)
{
string s = "select sx from test where parentId2 IN (select DISTINCT parentId2 from test where zId='" + a + "' and sx+0<='" + b + "'+0 and pId='" + c + "')";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select17(string a, string b, string c, string d, string e, string f)
{
string s = "SELECT sx from test WHERE parentId2 in( SELECT parentId2 FROM (select sx,zId,parentId2 from test where parentId2 in (select parentId2 from test where parentId = (select id from test where sx='" + a + "'and zId='" + b + "' and pId='" + c + "'and bh='" + d + "')))a WHERE sx+0<='" + e + "'+0 and zId ='" + f + "')";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select1()
{
string s = "SELECT zd from ziduan where zId in (SELECT zd from zd WHERE zd>=1 and zd<=10)";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select2(string a, string b)
{
string s = "SELECT sx from test WHERE zId>=1 and zId <=10 and pId='" + a + "'and lzId ='" + b + "'";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select1214()
{
string s = "SELECT lzId ,bh FROM zl2 WHERE iszl='1'";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select77777(string str, string str2)
{
string s = "SELECT max(id) FROM test2 where pId='" + str + "' and sx = '" + str2 + "' and zId = '3'";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select6(string str, string a, string b, string c, string d, string e)
{
string s = "select sx from test2 where parentId2=(select parentId2 from test2 where sx='" + str + "'and zId='" + a + "'and pId='" + b + "' and lzId='" + c + "') and pId='" + b + "'and lzId='" + c + "'and zId>='" + d + "' and zId<='" + e + "'";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select11(DateTime a, DateTime b, string c)
{
string s = "select useId ,username ,date ,morningwork ,morningend ,afternoonwork ,afternoonend ,mealsupport ,punish ,allwork from attendance where date >= '" + a + "' and date <= '" + b + "'and username like'%" + c + "%'";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select9()
{
string s = "select p1,p2,p3,cb from apmoney WHERE id = (select max(id) from apmoney)";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select(string str)
{
string s = "select gdmethod from project1 where pId ='" + str + "'";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select3(string str)
{
string s = "SELECT distinct gdmethod from fileprocess WHERE lzId='" + str + "'";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select8(string a, string b)
{
string s = "SELECT distinct page from nprocessing2 WHERE getId = (SELECT DISTINCT getId FROM fileprocess WHERE lzId = '" + a + "') and bh = '" + b + "'";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select4(string str)
{
string s = "SELECT sx from test WHERE pId='" + str + "'and zId >=4 and zId<=7";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select14(string a, string b)
{
string s = "select sx from test where parentId2=(SELECT parentId2 from test where sx='" + a + "' and pId='" + b + "')";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select6(string str)
{
string s = "SELECT zd FROM ziduan where zId IN (SELECT zd FROM zd where pId = '" + str + "' and zd >=19 AND zd<=29 )";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select1(string str)
{
string s = "SELECT zd from ziduan where zId in (SELECT zd from zd WHERE pId = '" + str + "' AND zd>=1 AND ZD<= 10)";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select7(string str)
{
string s = "select distinct pId from nprocessing2 where getId =(select distinct getId from fileprocess where lzId='" + str + "')";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select115(string a, string b, string c)
{
string s = "select bh from test where lzId='" + a + "'and zId='" + b + "'and sx='" + c + "'";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select99(string str, string str2)
{
string s = "select sx from test where pId ='" + str + "' and parentId2 in(select distinct parentId2 FROM test where parentId =(select id from test where zId=3 and sx='" + str2 + "' and pId='" + str + "'))";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select1113(string str, string b)
{
string s = "select id,sx,zId from test where pId = '" + str + "'and lzId ='" + b + "' and zId >= 19 and zId <= 29 ";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select9(string str)
{
string s = "select pId from test where sx='" + str + "'";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select4(string str)
{
string s = "SELECT id from test where pId ='" + str + "'and parentId = 0 ";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Selectinfo(string str)
{
string s = "select zId,pc from test where pId ='" + str + "'";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
public DataTable Select6(string a)
{
string s = "select zId from ziduan where zd ='" + a + "'";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
//对应打卡时间进行设置
public DataTable Select7()
{
string s = "select smw,sme,saw,sae from aspunch WHERE id = (select max(id) from aspunch)";
DataTable dt = DBhelper.GetTableBySql(s);
return(dt);
}
