public class MangeDal
{
//添加
public int addGoods(ManageModel m)
{
//写添加的sql语句
string sql = string.Format("insert into Goods(GName,GNum,GPrice,GSale,GTime,GContent,WaiJian) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", m.GName, m.GNum, m.GPrice, m.GSale, m.GTime, m.GContent, m.WaiJian);
//返回给Bll层
return DBHelper.ExecuteNonQuery(sql);
}
//查询商品分类表 为的是绑定下拉框
public List<ManageModel> showType()
{
//写查询分类表的sql语句
string sql = string.Format("select * from GoodsType");
//返回给bll
return DBHelper.GetToList<ManageModel>(sql);
}
//显示 商品表和类别表
public List<ManageModel> showGoods(string GName,string WaiJian,string GSale)
{
//定义一个恒成立
string sql = "select * from Goods join GoodsType On Goods.WaiJian = GoodsType.TId where 1=1";
if(GName!="")
{
//拼接sql
sql += " and GName like '%" + GName + "%'";
}
if(WaiJian!="请选择")
{
//拼接sql
sql += " and WaiJian=" + WaiJian;
}
if(GSale=="1" || GSale=="0")
{
sql += " and GSale=" + GSale;
}
//调用DBhelper返回给BLL
return DBHelper.GetToList<ManageModel>(sql);
}
//减商品数量
public int jian(int GId)
{
//减少商品数量
string sql = string.Format("update Goods set GNum-=1 where GId=" + GId);
return DBHelper.ExecuteNonQuery(sql);
}
//增商品数量
public int jia(int GId)
{
//减少商品数量
string sql = string.Format("update Goods set GNum+=1 where GId=" + GId);
return DBHelper.ExecuteNonQuery(sql);
}
//反填
public List<ManageModel> showGoodsOne(int GId)
{
//写反填的sql语句
string sql = string.Format("select * from Goods join GoodsType On Goods.WaiJian = GoodsType.TId where GId = " + GId);
return DBHelper.GetToList<ManageModel>(sql);
}
//修改的sql语句
public int gaIGoods(ManageModel m)
{
//写修改的sql语句
string sql = string.Format("update Goods set GName='{0}',GNum='{1}',GPrice='{2}',GSale='{3}',GTime='{4}',GContent='{5}',WaiJian='{6}' where GId='{7}'", m.GName, m.GNum, m.GPrice, m.GSale, m.GTime, m.GContent, m.WaiJian, m.GId);
return DBHelper.ExecuteNonQuery(sql);
}
//批量删除语句
public int pishan(string GId)
{
//写批删语句
string sql = string.Format("delete from Goods where GId in (" + GId + ")");
return DBHelper.ExecuteNonQuery(sql);
}
//去结算(添加信息到订单里)
public int addOrder(string GId)
{
//添加语句
string sql = string.Format("insert into Orders select GName,GNum,GPrice,0 from Goods where GId in (" + GId + ")");
return DBHelper.ExecuteNonQuery(sql);
}
//显示订单
public List<ManageModel> showOrder()
{
//写查询的sql语句
string sql = string.Format("select * from Orders");
return DBHelper.GetToList<ManageModel>(sql);
}
//批量修改状态
public int goPay(string OId)
{
//批量修改的sql语句
string sql = string.Format("update Orders set OPay=1 where OId in (" + OId + ")");
return DBHelper.ExecuteNonQuery(sql);
}