/// <summary> /// 插入操作 /// </summary> /// <param name="dti"></param> /// <returns></returns> public int Insert(DishTypeInfo dti) { string sql = "insert into dishtypeinfo(dtitle,disdelete) values(@title,0)"; SQLiteParameter sp = new SQLiteParameter("@title", dti.DTitle); return(SqliteHelper.ExcuteNoQuery(sql, sp)); }
public int OrderDish(int orderid, int dishid) { //查询当前是否已经点了这道菜,若是则加1,若不死 string sql = "select count(*) from orderdetailinfo where orderid=@oid and dishid=@did"; SQLiteParameter[] sp = new SQLiteParameter[] { new SQLiteParameter("@oid", orderid), new SQLiteParameter("@did", dishid), }; int count = Convert.ToInt32(SqliteHelper.ExcuteScalar(sql, sp)); if (count > 0) { //已经点过这道菜 sql = "update orderdetailinfo set count=count+1 where orderid=@oid and dishid=@did"; } else { //还没点过 sql = "insert into orderdetailinfo(orderid,dishid,count) values(@oid,@did,1)"; } return(SqliteHelper.ExcuteNoQuery(sql, sp)); #endregion }
/// <summary> /// 删除管理员 /// </summary> /// <param name="mi"></param> /// <returns></returns> public int Delete(int id) { string sql = "delete from managerinfo where mid=@id"; SQLiteParameter sp = new SQLiteParameter("@id", id); return(SqliteHelper.ExcuteNoQuery(sql, sp)); }
public int Delete(int index) { string sql = "delete from orderdetailinfo where oid=@id "; SQLiteParameter sp = new SQLiteParameter("@id", index); return(SqliteHelper.ExcuteNoQuery(sql, sp)); }
/// <summary> /// 添加操作 /// </summary> /// <param name="hi"></param> /// <returns></returns> public int Insert(HallInfo hi) { string sql = "insert into hallinfo (htitle,hisdelete) values(@title,0)"; SQLiteParameter sp = new SQLiteParameter("@title", hi.HTitle); return(SqliteHelper.ExcuteNoQuery(sql, sp)); }
public int Delete(int index) { string sql = "update hallinfo set hisdelete =1 where hid=@id"; SQLiteParameter sp = new SQLiteParameter("@id", index); return(SqliteHelper.ExcuteNoQuery(sql, sp)); }
/// <summary> /// 插入新的数据 /// </summary> /// <param name="vip"></param> /// <returns></returns> public int Insert(VIPTypeInfo vip) { string sql = "insert into membertypeinfo(mtitle,mdiscount,misdelete) values(@title,@discount,0)"; SQLiteParameter[] sp = { new SQLiteParameter("@title",vip.MTitle), new SQLiteParameter("@discount",vip.MDiscount) }; return SqliteHelper.ExcuteNoQuery(sql, sp); }
/// <summary> /// 修改数据 /// </summary> /// <param name="dti"></param> /// <returns></returns> public int Update(DishTypeInfo dti) { string sql = "update dishtypeinfo set dtitle =@title where did=@id"; SQLiteParameter[] sp = { new SQLiteParameter("@title", dti.DTitle), new SQLiteParameter("@id", dti.DId), }; return(SqliteHelper.ExcuteNoQuery(sql, sp)); }
/// <summary> /// 修改操作 /// </summary> /// <param name="hi"></param> /// <returns></returns> public int Update(HallInfo hi) { string sql = "update hallinfo set htitle=@title where hid=@id"; SQLiteParameter [] sp = new SQLiteParameter[] { new SQLiteParameter("@title", hi.HTitle), new SQLiteParameter("@id", hi.HId), }; return(SqliteHelper.ExcuteNoQuery(sql, sp)); }
/// <summary> /// 修改数据 /// </summary> /// <param name="vip"></param> /// <returns></returns> public int Update(VIPTypeInfo vip) { string sql = "update membertypeinfo set mtitle=@title,mdiscount=@discount where mid=@id"; SQLiteParameter[] sp = { new SQLiteParameter("@id",vip.MId), new SQLiteParameter("@title",vip.MTitle), new SQLiteParameter("@discount",vip.MDiscount), }; return SqliteHelper.ExcuteNoQuery(sql, sp); }
public int UpdateCountByOrderId(int orderid, int count) { string sql = "update orderdetailinfo set count=@count where orderid=@orderid"; SQLiteParameter[] sp = new SQLiteParameter[] { new SQLiteParameter("@count", count), new SQLiteParameter("@orderid", orderid), }; return(SqliteHelper.ExcuteNoQuery(sql, sp)); }
public int CommitOrder(int orderid, int totalprice) { string sql = "update orderinfo set omoney=@money where oid=@oid"; SQLiteParameter[] sp = new SQLiteParameter[] { new SQLiteParameter("@money", totalprice), new SQLiteParameter("oid", orderid), }; return(SqliteHelper.ExcuteNoQuery(sql, sp)); }
/// <summary> /// 插入数据 /// </summary> /// <param name="ti"></param> /// <returns></returns> public int Insert(TableInfo ti) { string sql = "insert into tableinfo(ttitle,thallid,tisfree,tisdelete) values(@title,@hallid,@isfree,0)"; SQLiteParameter [] sp = new SQLiteParameter[] { new SQLiteParameter("@title", ti.TTitle), new SQLiteParameter("@hallid", ti.THallId), new SQLiteParameter("@isfree", ti.TIsFree), }; return(SqliteHelper.ExcuteNoQuery(sql, sp)); }
/// <summary> /// 修改数据 /// </summary> /// <param name="ti"></param> /// <returns></returns> public int Update(TableInfo ti) { string sql = "update tableinfo set ttitle=@title,thallid=@hallid,tisfree=@isfree where tid=@id"; SQLiteParameter [] sp = new SQLiteParameter[] { new SQLiteParameter("@title", ti.TTitle), new SQLiteParameter("@hallid", ti.THallId), new SQLiteParameter("@isfree", ti.TIsFree), new SQLiteParameter("@id", ti.TId), }; return(SqliteHelper.ExcuteNoQuery(sql, sp)); }
/// <summary> /// 插入数据 /// </summary> /// <param name="mi">在UI层封装好的模型对象</param> /// <returns></returns> public int Insert(ManagerInfo mi) { //构建insert语句 string sql = "insert into managerinfo(mname,mpwd,mtype) values(@name,@pwd,@type)"; SQLiteParameter[] sp = { new SQLiteParameter("@name", mi.MName), new SQLiteParameter("@pwd", MD5Helper.GetMD5String(mi.MPwd)), new SQLiteParameter("@type", mi.MType), }; return(SqliteHelper.ExcuteNoQuery(sql, sp)); }
/// <summary> /// 修改 /// </summary> /// <param name="dish"></param> /// <returns></returns> public int Update(DishInfo dish) { string sql = "update dishinfo set dtitle=@title,dtypeid=@typeid,dprice=@price where did=@id"; SQLiteParameter [] sp = new SQLiteParameter[] { new SQLiteParameter("@title", dish.DTitle), new SQLiteParameter("@typeid", dish.DTypeId), new SQLiteParameter("@price", dish.DPrice), new SQLiteParameter("@id", dish.DId), }; return(SqliteHelper.ExcuteNoQuery(sql, sp)); }
/// <summary> /// 插入新数据 /// </summary> /// <param name="dish"></param> /// <returns></returns> public int Insert(DishInfo dish) { string sql = "insert into dishinfo(dtitle,dtypeid,dprice,dchar,disdelete) values(@title,@typeid,@price,@char,0)"; SQLiteParameter [] sp = new SQLiteParameter[] { new SQLiteParameter("@title", dish.DTitle), new SQLiteParameter("@typeid", dish.DTypeId), new SQLiteParameter("@price", dish.DPrice), new SQLiteParameter("@char", dish.DChar), }; return(SqliteHelper.ExcuteNoQuery(sql, sp)); }
public int Update(VIPInfo vip) { string sql = "update memberinfo set mname=@name,mtypeid=@typeid,mphone=@phone,mmoney=@moneyn where mid=@id"; SQLiteParameter[] sp = { new SQLiteParameter("@id", vip.MId), new SQLiteParameter("@name", vip.MName), new SQLiteParameter("@typeid", vip.MTypeId), new SQLiteParameter("@phone", vip.MPhone), new SQLiteParameter("@money", vip.MCount), }; return(SqliteHelper.ExcuteNoQuery(sql, sp)); }
/// <summary> /// 插入新的数据 /// </summary> /// <param name="vi"></param> /// <returns></returns> public int Insert(VIPInfo vi) { string sql = "insert into memberinfo(mtypeid,mname,mphone,mmoney,misdelete) values(@typeid,@name,@phone,@money,@isdelete)"; SQLiteParameter[] sp = { new SQLiteParameter("@typeid", vi.MTypeId), new SQLiteParameter("@name", vi.MName), new SQLiteParameter("@phone", vi.MPhone), new SQLiteParameter("@money", vi.MCount), new SQLiteParameter("@isdelete", vi.MIsdelete), }; return(SqliteHelper.ExcuteNoQuery(sql, sp)); }
/// <summary> /// 修改管理员,注意到密码是否发生了修改 /// </summary> /// <param name="mi"></param> /// <returns></returns> public int Update(ManagerInfo mi) { //要进行密码的判断,因为最终密码要经过MD5加密,这是不可逆的 //若用户修改了密码,则重新加密,若没有,则不变 //对于这种更改条目不确定的情况,方法是对SQL语句和参数列表根据实际情况逐条相加,而不是写死。SQL语句可以使用字符串拼接,而参数列表就放在list集合中而不是数组中,因为数组的长度不可变,集合长度可变,这里明显list更好用! List <SQLiteParameter> sp = new List <SQLiteParameter>(); string sql = "update managerinfo set mname=@name,mtype=@type"; sp.Add(new SQLiteParameter("@name", mi.MName)); sp.Add(new SQLiteParameter("@type", mi.MType)); if (!mi.MPwd.Equals("这是原来的密码吗")) { sql += ",mpwd=@pwd"; sp.Add(new SQLiteParameter("@pwd", MD5Helper.GetMD5String(mi.MPwd))); } sql += " where mid=@id"; sp.Add(new SQLiteParameter("@id", mi.MId)); return(SqliteHelper.ExcuteNoQuery(sql, sp.ToArray())); }
public int Delete(int deleteid) { string sql = "update membertypeinfo set misdelete=1 where mid=@id"; SQLiteParameter sp=new SQLiteParameter("@id",deleteid); return SqliteHelper.ExcuteNoQuery(sql, sp); }