public int Insert(LectureCategoryRequirementItem item) { string query = "Insert into LectureCategoryRequirement(accountId,lectureCategoryId,cutline) VALUES(@AccountId,@LectureCategoryId,@Cutline)"; IDbParameters param = CreateDbParameters(); param.AddWithValue("AccountId", item.AccountId).DbType = DbType.Int32; param.AddWithValue("Cutline", item.Cutline).DbType = DbType.Int32; param.AddWithValue("LectureCategoryId", item.LectureCategoryId).DbType = DbType.Int32; return(AdoTemplate.ExecuteNonQuery(CommandType.Text, query, param)); }
public int Update(LectureCategoryRequirementItem item) { string query = "UPDATE LectureCategoryRequirement SET accountId = @AccountId, cutline = @Cutline, lectureCategoryId = @LectureCategoryId where id = @Id"; IDbParameters param = CreateDbParameters(); param.AddWithValue("AccountId", item.AccountId).DbType = DbType.Int32; param.AddWithValue("Cutline", item.Cutline).DbType = DbType.Int32; param.AddWithValue("Id", item.Id).DbType = DbType.Int32; param.AddWithValue("LectureCategoryId", item.LectureCategoryId).DbType = DbType.Int32; return(AdoTemplate.ExecuteNonQuery(CommandType.Text, query, param)); }