//返回都有什么类型 寄存管理的 并且加上数量
public List <jbcs> selectListAndCount(int type)
{
List <jbcs> list = new List <jbcs>();
jbcs model;
string dpname = FilterClass.DianPu1.UserName.Trim();
SqlParameter[] pms;
string str;
pms = new SqlParameter[] {
new SqlParameter("@type", type),
new SqlParameter("@DPName", dpname)
};
str = "select b.text,count(a.jcType) as aa from jbcstable as b join JCInfoTable" + ID + " as a on b.text=a.jcType where b.type=@type and b.DPName=@DPName and a.jcZT='未取走' group by a.jcType,b.text";
SqlDataReader read = SqlHelper.ExecuteReader(str, pms);
while (read.Read())
{
if (read.HasRows)
{
model = new jbcs();
model.AllType = read["text"].ToString().Trim() + "[" + read["aa"].ToString().Trim() + "]";
list.Add(model);
}
}
return(list);
}
public List <jbcs> selectDNWC(string dpname1)
{
string dpname = dpname1;
List <jbcs> list = new List <jbcs>();
jbcs model;
SqlParameter[] pms;
string str;
if (dpname == "admin")
{
pms = new SqlParameter[] { };
str = "select stName from staffTable";
}
else
{
pms = new SqlParameter[] {
new SqlParameter("@DPName", dpname)
};
str = "select stName from staffTable where DPName=@DPName";
}
SqlDataReader read = SqlHelper.ExecuteReader(str, pms);
while (read.Read())
{
if (read.HasRows)
{
model = new jbcs();
model.AllType = read["stName"].ToString().Trim();
list.Add(model);
}
}
return(list);
}
//根据类型查询莫一种类型的基本参数都有什么
public List <jbcs> selectList(int type)
{
List <jbcs> list = new List <jbcs>();
jbcs model;
string dpname = FilterClass.DianPu1.UserName.Trim();
SqlParameter[] pms;
string str;
pms = new SqlParameter[] {
new SqlParameter("@type", type),
new SqlParameter("@DPName", dpname)
};
str = "select text from jbcstable where type=@type and DPName=@DPName";
SqlDataReader read = SqlHelper.ExecuteReader(str, pms);
while (read.Read())
{
if (read.HasRows)
{
model = new jbcs();
model.AllType = read["text"].ToString().Trim();
list.Add(model);
}
}
return(list);
}
