/// <summary>
/// 查询
/// </summary>
/// <returns></returns>
public static DataTable Select()
{
string sql = "select * from ProductCategory";
return SqlHelper.Query(sql);
}
/// <summary>
/// 查询名字
/// </summary>
/// <param name="id">要查询的id</param>
/// <returns></returns>
public static string Selectname(int id)
{
string sql = "select * from ProductCategory where Id=" + id;
DataTable dt = SqlHelper.Query(sql);
DataRow row = dt.Rows[0];
return Convert.ToString(row["Name"]);
}
/// <summary>
/// 查询
/// </summary>
/// <param name="name">名字条件</param>
/// <param name="proid">类别条件</param>
/// <returns></returns>
public static DataTable Select(string name = "", int proid = 0)
{
string sql = "select ProductCategory.Name,Product.* from ProductCategory,Product where ProductCategory.Id=Product.CategoryId";
if (name != "")
{
sql += " and ProductName like'%" + name + "%'";
}
if (proid != 0)
{
sql += " and CategoryId=" + proid;
}
return SqlHelper.Query(sql);
}
/// <summary>
/// ID查数据
/// </summary>
/// <param name="id">要查询的id</param>
/// <returns></returns>
public static DataTable Selectid(int id)
{
string sql = "select * from Product where Id=" + id;
return SqlHelper.Query(sql);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id">要删除的id</param>
/// <returns></returns>
public static int Delete(int id)
{
string sql = "delete from Product where Id=" + id;
return SqlHelper.NoneQuery(sql);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="pro">表</param>
/// <returns>受影响的行数</returns>
public static int Update(Product pro)
{
int sj = Convert.ToInt32(pro.IsOnSale);
string sql = string.Format("update Product set ProductName='{0}',MarketPrice{1},SellingPrice{2},CategoryId{3},Introduction='{4}',IsOnSale={5} where Id={6}", pro.ProductName, pro.MarketPrice, pro.SellingPrice,pro.CategoryId,pro.Introduction, sj, pro.Id);
return SqlHelper.NoneQuery(sql);
}