/// <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);
}