public int Update(UserInfos t)
{
string sql = "update UserInfos set UserInfo_Name=@UserInfo_Name,UserInfo_Sex=@UserInfo_Sex,ID_Num=@ID_Num where UserInfo_Id=@UserInfo_Id";
return(DapperHelper <object> .Execut(sql, t));
}
public int Create(UserInfos t)
{
string sql = "insert into UserInfos values(@UserInfo_Name,@UserInfo_Sex,@ID_Num,@Phone_Num,@Address,@HeadImg)";
return(DapperHelper <object> .Execut(sql, t));
}
public int Delete(int id)
{
string sql = "delete from UserInfos where id=@id";
return(DapperHelper <object> .Execut(sql, new { id }));
}
public int Delete(int id)
{
string sql = "delete from Comments id=@id";
return(DapperHelper <object> .Execut(sql, new { id }));
}
public int Update(Roles t)
{
string sql = "update Comments set Role_Name=@Role_Name";
return(DapperHelper <object> .Execut(sql, t));
}
public int Update(Money t)
{
string sql = "update Money set Money_Num=@Money_Num,Recharge_Time=@Recharge_Time,User_Id=@User_Id";
return(DapperHelper <object> .Execut(sql, t));
}
public int Create(Roles t)
{
string sql = "insert into Roles values(@Role_Name)";
return(DapperHelper <object> .Execut(sql, t));
}
public int Update(Admin t)
{
string sql = "update Admin set Admin_Name=@Admin_Name,Admin_Pwd=@Admin_Pwd,Role_Id=@Role_Id";
return(DapperHelper <object> .Execut(sql, t));
}
public int Create(Money t)
{
string sql = "insert into Money values(@Money_Num,@Recharge_Time,@User_Id)";
return(DapperHelper <object> .Execut(sql, t));
}
public int Update(Rooms t)
{
string sql = "update Rooms set RoomType_Id=@RoomType_Id,Room_Num=@Room_Num,Room_State=@Room_State";
return(DapperHelper <object> .Execut(sql, t));
}
public int Create(Admin t)
{
string sql = "insert into Admin values(@Admin_Name,@Admin_Pwd,@Role_Id)";
return(DapperHelper <object> .Execut(sql, t));
}
public int Create(Rooms t)
{
string sql = "insert into Rooms values(@RoomType_Id,@Room_Num,@Room_State)";
return(DapperHelper <object> .Execut(sql, t));
}
public int Update(RoomType t)
{
string sql = "update RoomType set RoomType_Name=@RoomType_Name,RoomType_Price=@RoomType_Price";
return(DapperHelper <object> .Execut(sql, t));
}
public int Create(RoomType t)
{
string sql = "insert into RoomType values(@RoomType_Name,@RoomType_Price)";
return(DapperHelper <object> .Execut(sql, t));
}
public int Update(Orders t)
{
string sql = "update Orders set Room_State=@Room_State where Order_Id=@Order_Id";
return(DapperHelper <object> .Execut(sql, t));
}
public int Create(Orders t)
{
string sql = "insert into Orders values(@Order_Time,@Content,@Blog_Time,@User_Id,@Money_Received,@Money_Favorable,@Money_Should,@Type_Of_Payment,@CheckIn_Time,@Leave_Time,@Room_State)";
return(DapperHelper <object> .Execut(sql, t));
}