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