public static int deletetb(TablesMDL tb) { string sql = "delete from tables where tableid=@tableid"; List <SqlParameter> list = new List <SqlParameter>(); list.Add(new SqlParameter("@tableid", tb.tableid)); return(DBhelper.MyExecuteNonQuery(sql, list.ToArray())); }
public static int deleteroom(RoomTypeMDL rt) { string sql = "delete from roomtype where rtid=@rtid"; List <SqlParameter> list = new List <SqlParameter>(); list.Add(new SqlParameter("@rtid", rt.rtid)); return(DBhelper.MyExecuteNonQuery(sql, list.ToArray())); }
public static int deleteadmin(AdminsMDL a) { string sql = "delete from admins where userid=@userid"; List <SqlParameter> list = new List <SqlParameter>(); list.Add(new SqlParameter("@userid", a.userid)); return(DBhelper.MyExecuteNonQuery(sql, list.ToArray())); }
public static int insertroom(RoomTypeMDL rt) { string sql = "insert into roomtype(rtname,rtmount) values(@rtname,@rtmount)"; List <SqlParameter> list = new List <SqlParameter>(); list.Add(new SqlParameter("@rtname", rt.rtname)); list.Add(new SqlParameter("@rtmount", rt.rtmount)); return(DBhelper.MyExecuteNonQuery(sql, list.ToArray())); }
public static int insertadmin(AdminsMDL ad) { string sql = "insert into admins values(@username,@userpwd,@usercompellation,1,1,1,1)"; SqlParameter[] spt = { new SqlParameter("@username", ad.UserName), new SqlParameter("@userpwd", ad.UserPWD), new SqlParameter("@usercompellation", ad.UserCompellation) }; return(DBhelper.MyExecuteNonQuery(sql, spt)); }
public static int DeleteVip(int VipID) { string sql = "delete from Vips where VipID=@VipID"; SqlParameter[] sp = { new SqlParameter("@VipID", VipID) }; return(DBhelper.MyExecuteNonQuery(sql, sp)); }
public static int updatepwd(AdminsMDL a, AdminsMDL aa) { string sql = "update admins set userpwd=@Uerpwd where username=@username and userpwd=@Userpwd"; List <SqlParameter> list = new List <SqlParameter>(); list.Add(new SqlParameter("@username", a.UserName)); list.Add(new SqlParameter("@userpwd", a.UserPWD)); list.Add(new SqlParameter("@Uerpwd", aa.UserPWD)); return(DBhelper.MyExecuteNonQuery(sql, list.ToArray())); }
public static int logintype(AdminsMDL a) { string sql = "update admins set LoginType=@logintype where username=@username "; List <SqlParameter> list = new List <SqlParameter>(); list.Add(new SqlParameter("@username", a.UserName)); list.Add(new SqlParameter("@logintype", a.LoginType)); return(Convert.ToInt32(DBhelper.MyExecuteNonQuery(sql, list.ToArray()))); }
/// <summary> /// 删除商品 /// </summary> /// <param name="ProductID"></param> /// <returns></returns> public static int DeleteProducts(int ProductID) { string sql = "delete from Products where ProductID=@ProductID"; SqlParameter [] sp = { new SqlParameter("@ProductID", ProductID) }; return(DBhelper.MyExecuteNonQuery(sql, sp)); }
public static int UPTB(string YDID) { string sql_U = "update Tables set TableState=0 where TableID in (select TBID from YuDing where YDID=@YDID)"; SqlParameter[] sp_U = { new SqlParameter("@YDID", YDID) }; return(DBhelper.MyExecuteNonQuery(sql_U, sp_U)); }
public static int updateroom(RoomTypeMDL rt) { string sql = "update roomtype set rtname=@rtname,rtmount=@rtmount where rtid=@rtid"; List <SqlParameter> list = new List <SqlParameter>(); list.Add(new SqlParameter("@rtname", rt.rtname)); list.Add(new SqlParameter("@rtmount", rt.rtmount)); list.Add(new SqlParameter("@rtid", rt.rtid)); return(DBhelper.MyExecuteNonQuery(sql, list.ToArray())); }
public static int deletevg(VipGradeMDL vg) { string sql = "delete from vipgrade where vgid=@vgid"; SqlParameter[] spt = { new SqlParameter("@vgid", vg.vgid) }; return(DBhelper.MyExecuteNonQuery(sql, spt)); }
public static int updateadmin(AdminsMDL a) { string sql = "update admins set username=@username,usercompellation=@usercompellation where userid=@userid"; List <SqlParameter> list = new List <SqlParameter>(); list.Add(new SqlParameter("@username", a.UserName)); list.Add(new SqlParameter("@usercompellation", a.UserCompellation)); list.Add(new SqlParameter("@userid", a.userid)); return(DBhelper.MyExecuteNonQuery(sql, list.ToArray())); }
public static int UpTable(string CBID, int TBID) { string sql = "update ConsumerBill set TableID=@TableID where CBID=@CBID"; SqlParameter[] sp = { new SqlParameter("@TableID", TBID), new SqlParameter("@CBID", CBID), }; return(DBhelper.MyExecuteNonQuery(sql, sp)); }
public static int UpdateTables(int TableID, int State) { string sql = "update Tables set TableState=@TableState where TableID=@TableID"; SqlParameter[] sp = { new SqlParameter("@TableState", State), new SqlParameter("@TableID", TableID) }; return(DBhelper.MyExecuteNonQuery(sql, sp)); }
public static int insertvg(VipGradeMDL vg) { string sql = "insert into vipgrade values(@vgname,@vgdiscount)"; SqlParameter[] spt = { new SqlParameter("@vgname", vg.vgname), new SqlParameter("@vgdiscount", vg.vgdiscount) }; return(DBhelper.MyExecuteNonQuery(sql, spt)); }
public static int DeleteYD(string YDID) { string sql = "delete from YuDing where YDID=@YDID"; SqlParameter[] sp = { new SqlParameter("@YDID", YDID) }; return(DBhelper.MyExecuteNonQuery(sql, sp)); }
public static int updatetb(TablesMDL tb) { string sql = "update tables set tablename=@tablename,rtid=@rtid,tablearea=@tablearea where tableid=@tableid"; List <SqlParameter> list = new List <SqlParameter>(); list.Add(new SqlParameter("@tablename", tb.tablename)); list.Add(new SqlParameter("@rtid", tb.rtid)); list.Add(new SqlParameter("@tablearea", tb.tablearea)); list.Add(new SqlParameter("@tableid", tb.tableid)); return(DBhelper.MyExecuteNonQuery(sql, list.ToArray())); }
public static int inserttb(TablesMDL tb) { string sql = "insert into tables values(@tablename,@rtid,@tablearea,@tablestate)"; List <SqlParameter> list = new List <SqlParameter>(); list.Add(new SqlParameter("@tablename", tb.tablename)); list.Add(new SqlParameter("@rtid", tb.rtid)); list.Add(new SqlParameter("@tablearea", tb.tablearea)); list.Add(new SqlParameter("@tablestate", tb.tablestate)); return(DBhelper.MyExecuteNonQuery(sql, list.ToArray())); }
public static int updatevg(VipGradeMDL vg) { string sql = "update vipgrade set vgname=@vgname,vgdiscount=@vgdiscount where vgid=@vgid"; SqlParameter[] spt = { new SqlParameter("@vgname", vg.vgname), new SqlParameter("@vgdiscount", vg.vgdiscount), new SqlParameter("@vgid", vg.vgid) }; return(DBhelper.MyExecuteNonQuery(sql, spt)); }
public static int RemoveConsumerDetails(int PTID) { string sql = @"delete from ConsumerDetail where ProdcutID=@ProdcutID and CDID=(select MAX(CDID) from dbo.ConsumerDetail where ProdcutID=@ProdcutID)"; SqlParameter[] sp = { new SqlParameter("@ProdcutID", PTID) }; return(DBhelper.MyExecuteNonQuery(sql, sp)); }
public static int UPCB(ConsumerBills c) { string sql = "update dbo.ConsumerBill set CBClose=1,VipID=@VipID,CBDiscount=@CBDiscount,CBEndDate=GETDATE(),AdminID=@AdminID,CBSale=@CBSale where CBID=@CBID"; SqlParameter[] sp = { new SqlParameter("@CBID", c.CBID), new SqlParameter("@VipID", c.VipID), new SqlParameter("@CBDiscount", c.CBDiscount), new SqlParameter("@AdminID", c.AdminID), new SqlParameter("@CBSale", c.CBSale), }; return(DBhelper.MyExecuteNonQuery(sql, sp)); }
public static int AddVip(VipsMDL v) { string sql = "insert into Vips values(@VipName,@VipSex,@GradeID,@VipTel,GETDATE(),@VipEndDate)"; SqlParameter[] sp = { new SqlParameter("@VipName", v.VipName), new SqlParameter("@VipSex", v.VipSex), new SqlParameter("@GradeID", v.GradeID), new SqlParameter("@VipTel", v.VipTel), new SqlParameter("@VipEndDate", v.VipEndDate), }; return(DBhelper.MyExecuteNonQuery(sql, sp)); }
/// <summary> /// 增加消费 /// </summary> /// <param name="c"></param> /// <returns></returns> public static int AddCB(ConsumerBills c) { string sql = @"insert into ConsumerBill(CBID,TableID,CBAmount,CBStartDate,CBClose) values(@CBID,@TableID,@CBAmount,@CBStartDate,@CBClose)"; SqlParameter[] sp = { new SqlParameter("@CBID", c.CBID), new SqlParameter("@TableID", c.TableID), new SqlParameter("@CBAmount", c.CBAmount), new SqlParameter("@CBStartDate", c.CBStartDate), new SqlParameter("@CBClose", c.CBClose) }; return(DBhelper.MyExecuteNonQuery(sql, sp)); }
public static int UpdateVip(VipsMDL v) { string sql = "update Vips set VipName=@VipName,VipSex=@VipSex,GradeID=@GradeID,VipTel=@VipTel,VipEndDate=@VipEndDate where VipID=@VipID"; SqlParameter[] sp = { new SqlParameter("@VipName", v.VipName), new SqlParameter("@VipSex", v.VipSex), new SqlParameter("@VipTel", v.VipTel), new SqlParameter("@VipEndDate", v.VipEndDate), new SqlParameter("@GradeID", v.GradeID), new SqlParameter("@VipID", v.VipID) }; return(DBhelper.MyExecuteNonQuery(sql, sp)); }
/// <summary> /// 添加商品 /// </summary> /// <param name="p"></param> /// <returns>几行受影响</returns> public static int AddProducts(ProductsMDL p) { string sql = "insert into Products values(@ProductName,@PTID,@ProductJP,@ProductPrice,@ProductIntroduction,@ProductPic)"; SqlParameter[] sp = { new SqlParameter("@ProductName", p.ProductName), new SqlParameter("@PTID", p.PTID), new SqlParameter("@ProductJP", p.ProductJP), new SqlParameter("@ProductPrice", p.ProductPrice), new SqlParameter("@ProductIntroduction", p.ProductIntroduction), new SqlParameter("@ProductPic", p.ProductPic) }; return(DBhelper.MyExecuteNonQuery(sql, sp)); }
/// <summary> /// 保存菜单 /// </summary> /// <returns></returns> public static int AddConsumerDetails(ConsumerDetails c) { string sql = "insert into dbo.ConsumerDetail values(@CBID,@ProdcutID,@CDPrice,@CDAmount,@CDSale,@CDMoney,@CDType,GETDATE())"; SqlParameter[] sp = { new SqlParameter("@CBID", c.CBID), new SqlParameter("@ProdcutID", c.ProductID), new SqlParameter("@CDPrice", c.CDPrice), new SqlParameter("@CDAmount", c.CDAmount), new SqlParameter("@CDSale", c.CDSale), new SqlParameter("@CDMoney", c.CDMoney), new SqlParameter("@CDType", c.CDType), }; return(DBhelper.MyExecuteNonQuery(sql, sp)); }
/// <summary> /// 修改商品 /// </summary> /// <param name="p"></param> /// <returns></returns> public static int UpdateProducts(ProductsMDL p) { string sql = @" update Products set ProductName=@ProductName,PTID=@PTID,ProductPrice=@ProductPrice,ProductIntroduction=@ProductIntroduction,ProductPic=@ProductPic where ProductID=@ProductID"; SqlParameter[] sp = { new SqlParameter("@ProductName", p.ProductName), new SqlParameter("@PTID", p.PTID), new SqlParameter("@ProductPrice", p.ProductPrice), new SqlParameter("@ProductID", p.ProductID), new SqlParameter("@ProductIntroduction", p.ProductIntroduction), new SqlParameter("@ProductPic", p.ProductPic) }; return(DBhelper.MyExecuteNonQuery(sql, sp)); }
public static int AddYd(YDMDL y) { string sql = "insert into YuDing values(@YDID,@KName,@KPhone,@RTID,@TBID,@YTime,@YJ,@Price,@bz,@daoda)"; SqlParameter[] sp = { new SqlParameter("@YDID", y.YDID), new SqlParameter("@KName", y.KName), new SqlParameter("@KPhone", y.KPhone), new SqlParameter("@RTID", y.RTID), new SqlParameter("@TBID", y.TBID), new SqlParameter("@YTime", y.YTime), new SqlParameter("@YJ", y.YJ), new SqlParameter("@Price", y.Price), new SqlParameter("@bz", y.bz), new SqlParameter("@daoda", y.daoda), }; return(DBhelper.MyExecuteNonQuery(sql, sp)); }