public bool UpdateConfig(string bindIds, DeliveryConfigAttr attr, DeliveryConfigType configType) { List <DeliveryConfig> config = GetConfig(bindIds, configType); List <DeliveryConfig> newConfig = bindIds.ConvertToIntList(',')? .Where(id => !config.Exists(item => item.BindId == id)) .Select(id => new DeliveryConfig() { BindId = id, Type = (int)configType }) .ToList(); TransactionModel tran = new TransactionModel(); config?.ForEach(item => { item.SetAttrbute(attr); tran.Add(BuildUpdateSql(item, "attr")); }); newConfig?.ForEach(item => { item.SetAttrbute(attr); tran.Add(BuildAddSql(item)); }); return(ExecuteTransactionDataCorect(tran.sqlArray, tran.ParameterArray)); }
public List <DeliveryConfig> GetConfig(string bindIds, DeliveryConfigType configType) { string whereSql = BuildWhereSql(bindIds: bindIds, configType: configType); return(GetList(whereSql)); }
public DeliveryConfig GetConfig(int bindId, DeliveryConfigType configType) { return(GetConfig(bindId.ToString(), configType).FirstOrDefault()); }