/// <summary> /// 保存某采购的所有通知记录 /// </summary> /// <param name="purchaerId"> </param> /// <param name="inform"></param> /// <param name="result"></param> /// <param name="remark"></param> /// <param name="operatorAccount"> </param> /// <param name="operatorName"> </param> /// <returns></returns> public static bool InformPurchaser(Guid purchaerId, InformType inform, InformResult result, string remark, string operatorAccount, string operatorName) { return(InformPurchaser(purchaerId, null, inform, result, remark, operatorAccount, operatorName)); }
/// <summary> /// 保存通知记录 /// </summary> /// <param name="purchaerId"> </param> /// <param name="transferIds"></param> /// <param name="inform"></param> /// <param name="result"></param> /// <param name="remark"></param> /// <param name="operatorAccount"> </param> /// <param name="operatorName"> </param> /// <returns></returns> public bool InformPurchaser(Guid purchaerId, List <Guid> transferIds, InformType inform, InformResult result, string remark, string operatorAccount, string operatorName) { string sql = string.Empty; if (transferIds == null) { sql = @"UPDATE [T_FlightTransfer] SET [InformStatus] = @InformStatus,InformMethod = @InformMethod, InformRemark = @InformRemark,InformTime=@InformTime, InformerAcount =@InformerAccount,InformerName=@InformerName WHERE PurchaserId = @PurchaserId"; } else { sql = @"UPDATE [T_FlightTransfer] SET [InformStatus] = @InformStatus,InformMethod = @InformMethod, InformRemark = @InformRemark,InformTime=@InformTime, InformerAcount =@InformerAccount,InformerName=@InformerName WHERE PurchaserId = @PUrchaserId and TransferId in ('"; sql += string.Join("','", transferIds); sql += "')"; } AddParameter("@PurchaserId", purchaerId); AddParameter("@InformStatus", (byte)result); AddParameter("@InformMethod", (byte)inform); AddParameter("@InformTime", DateTime.Now); AddParameter("@InformRemark", remark); AddParameter("@InformerAccount", operatorAccount); AddParameter("@InformerName", operatorName); return(ExecuteNonQuery(sql) > 0); }
/// <summary> /// 保存通知记录 /// </summary> /// <param name="purchaerId"> </param> /// <param name="transferIds"></param> /// <param name="inform"></param> /// <param name="result"></param> /// <param name="remark"></param> /// <param name="operatorAccount"> </param> /// <param name="operatorName"> </param> /// <returns></returns> public static bool InformPurchaser(Guid purchaerId, List <Guid> transferIds, InformType inform, InformResult result, string remark, string operatorAccount, string operatorName) { using (var command = Factory.CreateCommand()) { var transferInfomationRepository = Factory.CreateTransfeRepository(command); return(transferInfomationRepository.InformPurchaser(purchaerId, transferIds, inform, result, remark, operatorAccount, operatorName)); } }