public static bool Insert(BaseStatus baseStatus, SqlConnection conn, SqlTransaction trans) { const string sql = @" INSERT INTO T_BASE_STATUS(STATUS_ID,STATUS_NAME,GROUP_NAME,CREATED_ON,CREATED_BY) VALUES(@StatusId,@StatusName,@GroupName,CONVERT(NVARCHAR(50),GETDATE(),121),@CreatedBy) "; return Dapper.Save(baseStatus, sql, conn, trans); }
public static bool Delete(BaseStatus baseStatus) { const string sql = @" DELETE FROM T_BASE_STATUS WHERE ID=@ID "; return Dapper.Save(baseStatus, sql); }
public static bool Delete(BaseStatus baseStatus, SqlConnection conn, SqlTransaction trans) { const string sql = @" DELETE FROM T_BASE_STATUS WHERE ID=@ID "; return Dapper.Save(baseStatus, sql, conn, trans); }
public static bool Update(BaseStatus baseStatus, SqlConnection conn, SqlTransaction trans) { const string sql = @" UPDATE T_BASE_STATUS SET STATUS_ID=@StatusId,STATUS_NAME=@StatusName,GROUP_NAME=@GroupName,CREATED_BY=@CreatedBy WHERE ID=@ID "; return Dapper.Save(baseStatus, sql, conn, trans); }