public ClassCtrl(string _acc, string ClassID)
{
Account = _acc;
string str = "select * from ProductClass where ParentID=''";
DataTable dt = db.getTable(str, Account);
ParentClassList = CommonTools.TableToList <ProductClass>(dt);
string strsql = "select * from ProductClass where SID='" + ClassID + "'";
DataTable dt1 = db.getTable(strsql, Account);
if (dt1 != null && dt1.Rows.Count > 0)
{
DataRow dr = dt1.Rows[0];
ProductClass = new ProductClass();
ProductClass.SID = dr["SID"].ToString();
ProductClass.ClassName = dr["ClassName"].ToString();
ProductClass.ParentID = dr["ParentID"].ToString();
ProductClass.ID = int.Parse(dr["ID"].ToString());
Code = "0000";
Msg = "成功";
}
else
{
ProductClass = new ProductClass();
Code = "0001";
Msg = "未查到该类别";
}
}
public List <ProductClass> ChildClassList(string parentID)
{
string str = "select * from ProductClass where ParentID='" + parentID + "'";
DataTable dt = db.getTable(str, Account);
return(CommonTools.TableToList <ProductClass>(dt));
}
public List <Department> GetList()
{
string str = "select * from Department order by SID desc";
DataTable dt = db.getTable(str, Account);
return(CommonTools.TableToList <Department>(dt));
}
public List <Warehouses> GetList()
{
string str = "select * from Warehouses order by ID desc";
DataTable dt = db.getTable(str, Account);
return(CommonTools.TableToList <Warehouses>(dt));
}
public List <Units> GetList(string sid)
{
string str = "select * from Units where SID <> '" + sid + "' order by SID desc";
DataTable dt = db.getTable(str, Account);
return(CommonTools.TableToList <Units>(dt));
}
public ClassCtrl(string _acc)
{
Account = _acc;
string str = "select * from ProductClass where ParentID=''";
DataTable dt = db.getTable(str, Account);
ParentClassList = CommonTools.TableToList <ProductClass>(dt);
string str1 = "select * from ProductClass order by SID";
AllClassList = CommonTools.TableToList <ProductClass>(db.getTable(str1, Account));
}
public List <UserInfo> UserList()
{
StringBuilder sqlstr = new StringBuilder();
sqlstr.Append("select a.*,b.DepartName from UserInfo as a ");
sqlstr.Append("left join Department as b on a.DepartID=b.SID ");
sqlstr.Append("order by a.SID desc");
DataTable dt = db.getTable(sqlstr.ToString(), Account);
return(CommonTools.TableToList <UserInfo>(dt));
}
public List <Products> GetList()
{
StringBuilder sqlstr = new StringBuilder();
sqlstr.Append("select a.*,b.ClassName,c.UnitName as MainUnitName,d.UnitName as AssistUnitName from Products as a ");
sqlstr.Append("left join ProductClass as b on a.ClassID=b.SID ");
sqlstr.Append("left join Units as c on a.MainUnit = c.SID ");
sqlstr.Append("left join Units as d on a.AssistUnit = d.SID ");
sqlstr.Append("order by a.SID desc");
DataTable dt = db.getTable(sqlstr.ToString(), Account);
return(CommonTools.TableToList <Products>(dt));
}
