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