////更新商品数量
//public static bool UpdateSum(int sum, int proID)
//{
// Database db = DatabaseFactory.CreateDatabase("ConStr");
// string sql = string.Format(@"update ");
//}
/// <summary>
/// 模糊查询商品
/// </summary>
/// <returns></returns>
public static List <ProAndSupply> MohuCheckProduct(string proname)
{
Database db = DatabaseFactory.CreateDatabase("Constr");
string sql = "select * from t_Products where ProductsName like '%" + proname + "%'";
DataSet ds = db.ExecuteDataSet(CommandType.Text, sql);
List <ProAndSupply> list = new List <ProAndSupply>();
foreach (DataRow item in ds.Tables[0].Rows)
{
ProAndSupply p = new ProAndSupply();
p.ProductsID = int.Parse(item["ProductsID"].ToString());
p.ProductsName = item["ProductsName"].ToString();
list.Add(p);
}
return(list);
}
/// <summary>
/// 引用供应商
/// </summary>
/// <returns></returns>
public static List <ProAndSupply> SelectSupply()
{
Database db = DatabaseFactory.CreateDatabase("Constr");
string sql = "select * from t_Supplier";
DataSet ds = db.ExecuteDataSet(CommandType.Text, sql);
List <ProAndSupply> list = new List <ProAndSupply>();
foreach (DataRow item in ds.Tables[0].Rows)
{
ProAndSupply p = new ProAndSupply();
p.SupplierID = int.Parse(item["SupplierID"].ToString());
p.SupplierName = item["SupplierName"].ToString();
p.Area = item["Area"].ToString();
list.Add(p);
}
return(list);
}
/// <summary>
/// 引用商品
/// </summary>
/// <returns></returns>
public static List <ProAndSupply> SelectProduct()
{
Database db = DatabaseFactory.CreateDatabase("Constr");
string sql = string.Format(@"select sum(BillNum) BillNum,t_Products.ProductsID,t_Products.ProductsName
from t_Products join t_Inventory on t_Products.ProductsID=t_Inventory.ProductsID
group by t_Products.ProductsID,t_Products.ProductsName");
DataSet ds = db.ExecuteDataSet(CommandType.Text, sql);
List <ProAndSupply> list = new List <ProAndSupply>();
foreach (DataRow item in ds.Tables[0].Rows)
{
ProAndSupply p = new ProAndSupply();
p.ProductsID = int.Parse(item["ProductsID"].ToString());
p.ProductsName = item["ProductsName"].ToString();
p.BillNum = int.Parse(item["BillNum"].ToString());
list.Add(p);
}
return(list);
}
