public int AddAndUpdate(ProductInfo pro, string sql, int temp)
{
List <SQLiteParameter> list = new List <SQLiteParameter>();
SQLiteParameter[] param =
{
new SQLiteParameter("@CatId", pro.CatId),
new SQLiteParameter("@ProName", pro.ProName),
new SQLiteParameter("@ProCost", pro.ProCost),
new SQLiteParameter("@ProSpell", pro.ProSpell),
new SQLiteParameter("@ProPrice", pro.ProPrice),
new SQLiteParameter("@ProUnit", pro.ProUnit),
new SQLiteParameter("@Remark", pro.Remark),
new SQLiteParameter("@ProStock", pro.ProStock),
new SQLiteParameter("@ProNum", pro.ProNum)
};
list.AddRange(param);
if (temp == 3)//新增
{
list.Add(new SQLiteParameter("@DelFlag", pro.DelFlag));
list.Add(new SQLiteParameter("@SubTime", pro.SubTime));
list.Add(new SQLiteParameter("@SubBy", pro.SubBy));
}
else if (temp == 4)//修改
{
list.Add(new SQLiteParameter("@ProId", pro.ProId));
}
return(SqliteHelper.ExecuteNonquery(sql, list.ToArray()));
}
//增加修改
private int AddAndUpdate(DeskInfo dk, string sql, int tp)
{
List <SQLiteParameter> list = new List <SQLiteParameter>();
SQLiteParameter[] param =
{
new SQLiteParameter("@RoomId", dk.RoomId),
new SQLiteParameter("@DeskName", dk.DeskName),
new SQLiteParameter("@DeskRemark", dk.DeskRemark),
new SQLiteParameter("@DeskRegion", dk.DeskRegion)
};
list.AddRange(param);
if (tp == 3)
{
list.Add(new SQLiteParameter("@DelFlag", dk.DelFlag));
list.Add(new SQLiteParameter("@SubTime", dk.SubTime));
list.Add(new SQLiteParameter("@SubBy", dk.SubBy));
list.Add(new SQLiteParameter("@DeskState", dk.DeskState));
}
else if (tp == 4)
{
list.Add(new SQLiteParameter("@DeskId", dk.DeskId));
}
return(SqliteHelper.ExecuteNonquery(sql, list.ToArray()));
}
//temp 1是新增，2是修改
public int AddAndUpdate(string sql, MemmberInfo mem, int temp)
{
List <SQLiteParameter> list = new List <SQLiteParameter>();
SQLiteParameter[] param =
{
new SQLiteParameter("@MemName", mem.MemName),
new SQLiteParameter("@MemMobilePhone", mem.MemMobilePhone),
new SQLiteParameter("@MemType", mem.MemType),
new SQLiteParameter("@MemNum", mem.MemNum),
new SQLiteParameter("@MemGender", mem.MemGender),
new SQLiteParameter("@MemDiscount", mem.MemDiscount),
new SQLiteParameter("@MemMoney", mem.MemMoney),
new SQLiteParameter("@MemIntegral", mem.MemIntegral),
new SQLiteParameter("@MemEndServerTime", mem.MemEndServerTime),
new SQLiteParameter("@MemBirthdaty", mem.MemBirthdaty)
};
list.AddRange(param);
if (temp == 1) //新增
{
list.Add(new SQLiteParameter("@DelFlag", mem.DelFlag));
list.Add(new SQLiteParameter("@SubTime", mem.SubTime));
}
else if (temp == 2) //修改
{
list.Add(new SQLiteParameter("@MemmberId", mem.MemmberId));
}
return(SqliteHelper.ExecuteNonquery(sql, list.ToArray()));
}
private int AddAndUpdate(RoomInfo room, string sql, int temp)
{
SQLiteParameter[] param =
{
new SQLiteParameter("@RoomName", room.RoomName),
new SQLiteParameter("@RoomType", room.RoomType),
new SQLiteParameter("@RoomMinimunConsume", room.RoomMinimunConsume),
new SQLiteParameter("@RoomMaxConsumer", room.RoomMaxConsumer),
new SQLiteParameter("@IsDefault", room.IsDefault)
};
List <SQLiteParameter> list = new List <SQLiteParameter>();
list.AddRange(param);
if (temp == 1)//新增
{
list.Add(new SQLiteParameter("@DelFlag", room.DelFlag));
list.Add(new SQLiteParameter("@Subtime", room.SubTime));
list.Add(new SQLiteParameter("@SubBy", room.SubBy));
}
else if (temp == 2)//修改
{
list.Add(new SQLiteParameter("@RoomId", room.RoomId));
}
return(SqliteHelper.ExecuteNonquery(sql, list.ToArray()));
}
/// <summary>
/// 向中间表插入一条数据
/// </summary>
/// <param name="rod">中间表对象</param>
/// <returns></returns>
public int AddROrderDesk(ROrderDesk rod)
{
string sql = "insert into R_Order_Desk(OrderId,DeskId) values(@OrderId,@DeskId)";
SQLiteParameter[] param =
{
new SQLiteParameter("@OrderId", rod.OrderId),
new SQLiteParameter("@DeskId", rod.DeskId)
};
return(SqliteHelper.ExecuteNonquery(sql, param));
}
/// <summary>
/// 根据餐桌的id修改该餐桌的状态
/// </summary>
/// <param name="deskId">餐桌的id</param>
/// <param name="temp">状态0--------空闲,1--------使用</param>
/// <returns></returns>
public int UpdateDeskStateByDeskId(int deskId, int temp)
{
string sql = "update DeskInfo set DeskState=@DeskState where DelFlag=0 and DeskId=@DeskId";
SQLiteParameter[] param =
{
new SQLiteParameter("@DeskState", temp),
new SQLiteParameter("@DeskId", deskId)
};
return(SqliteHelper.ExecuteNonquery(sql, param));
}
/// <summary>
/// 向中间表中插入一条数据,加菜
/// </summary>
/// <param name="roip">对象</param>
/// <returns></returns>
public int AddR_OrderInfo_Product(R_OrderInfo_Product roip)
{
string sql = "insert into R_OrderInfo_Product(OrderId,ProId,DelFlag,SubTime,State,UnitCount) values(@OrderId,@ProId,@DelFlag,@SubTime,@State,@UnitCount)";
SQLiteParameter[] param =
{
new SQLiteParameter("@OrderId", roip.OrderId),
new SQLiteParameter("@ProId", roip.ProId),
new SQLiteParameter("@DelFlag", roip.DelFlag),
new SQLiteParameter("@SubTime", roip.SubTime),
new SQLiteParameter("@State", roip.State),
new SQLiteParameter("@UnitCount", roip.UnitCount)
};
return(SqliteHelper.ExecuteNonquery(sql, param));
}
}//合并
private int AddAndUpdate(string sql, CategoryInfo cat, int temp)
{
List <SQLiteParameter> list = new List <SQLiteParameter>();
SQLiteParameter[] param =
{
new SQLiteParameter("@CatName", cat.CatName),
new SQLiteParameter("@CatNum", cat.CatNum),
new SQLiteParameter("@Remark", cat.Remark)
};
list.AddRange(param);
if (temp == 1)
{
list.Add(new SQLiteParameter("@DelFlag", cat.DelFlag));
list.Add(new SQLiteParameter("@SubTime", cat.SubTime));
list.Add(new SQLiteParameter("@SubBy", cat.SubBy));
}
else if (temp == 2)
{
list.Add(new SQLiteParameter("@CatId", cat.CatId));
}
return(SqliteHelper.ExecuteNonquery(sql, list.ToArray()));
}
/// <summary>
/// 删除产品
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int DeleteProductById(int id)
{
string sql = "update ProductInfo set DelFlag=1 where ProId=@ProId";
return(SqliteHelper.ExecuteNonquery(sql, new SQLiteParameter("@ProId", id)));
}
/// <summary>
/// 退菜
/// </summary>
/// <param name="ropId">中间表的主键id</param>
/// <returns></returns>
public int UpdateROrderProduct(int ropId)
{
string sql = "update R_OrderInfo_Product set DelFlag=1 where ROrderProId=@ROrderProId";
return(SqliteHelper.ExecuteNonquery(sql, new SQLiteParameter("@ROrderProId", ropId)));
}
/// <summary>
/// 根据房间的id删除删除
/// </summary>
/// <param name="roomId">房间的id</param>
/// <returns></returns>
public int DeleteDeskInfoByRoomId(int roomId)
{
string sql = "update DeskInfo set DelFlag=1 where RoomId=@RoomId";
return(SqliteHelper.ExecuteNonquery(sql, new SQLiteParameter("@RoomId", roomId)));
}
/// <summary>
/// 根据会员ID删除该会员
/// </summary>
/// <param name="memmberId">会员id</param>
/// <returns>受影响行数</returns>
public int DeleteMemmberByMemmberId(int memmberId)
{
string sql = "update MemmberInfo set DelFlag=1 where MemmberId=@MemmberId";
return(SqliteHelper.ExecuteNonquery(sql, new SQLiteParameter("@MemmberId", memmberId)));
}
public int DeleteCategoryById(int id)
{
string sql = "update CategoryInfo set DelFlag=1 where CatId=@CatId";
return(SqliteHelper.ExecuteNonquery(sql, new SQLiteParameter("@CatId", id)));
}