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