/// <summary>
/// 获取打开库存预警的商铺设置数据
/// </summary>
/// <returns></returns>
public List <StockAlertSetting> GetAlertSettings()
{
StringBuilder sqlStr = new StringBuilder();
var stockSettingList = new List <StockAlertSetting>();
sqlStr.Append(
"SELECT m.accId,n.CompanyName,m.alertStatus,m.alertTime,m.isWeb,m.isSms,m.isMob,m.isEmail FROM T_Goods_StockAlertSetting m LEFT JOIN dbo.T_Account n ON m.accId =n.ID WHERE m.alertStatus=1;");
var dataResult = DapperHelper.Query <dynamic>(sqlStr.ToString());
foreach (dynamic item in dataResult)
{
var stockSetting = new StockAlertSetting();
stockSetting.AccId = Convert.ToInt32(item.accId);
stockSetting.UserRealName = item.CompanyName;
stockSetting.AlertStatus = Convert.ToInt32(item.alertStatus);
stockSetting.AlertTime = Convert.ToInt32(item.alertTime);
stockSetting.IsWeb = Convert.ToInt32(item.isWeb);
stockSetting.IsSms = Convert.ToInt32(item.isSms);
stockSetting.IsMob = Convert.ToInt32(item.isMob);
stockSetting.IsEmail = Convert.ToInt32(item.isEmail);
stockSettingList.Add(stockSetting);
}
return(stockSettingList);
}
/// <summary>
/// 保存库存预警数据
/// </summary>
/// <returns></returns>
private int SaveSingleGoodsWarningData(StockAlertSetting stockalertInfo, GoodsInfoModel goodInfo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(goodInfo.IsExtend == 1
? " if(exists( SELECT id FROM [Sys_I200].[dbo].T_SingleGoodsWaring WHERE DATEDIFF(DAY,currentDate,@insertDate)=0 AND accId=@accId AND gid=@gid AND gsId=@gsId))"
: " if(exists( SELECT id FROM [Sys_I200].[dbo].T_SingleGoodsWaring WHERE DATEDIFF(DAY,currentDate,@insertDate)=0 AND accId=@accId AND gid=@gid AND gsId is null))");
strSql.Append(" begin");
strSql.Append(" select 1");
//strSql.Append("UPDATE T_SingleGoodsWaring SET userRealName=@userRealName,alertStatus=@alertStatus,alertTime=@alertTime,isWeb=@isWeb,isSms=@isSms,isMob=@isMob,isEmail=@isEmail,gQuantity=@gQuantity,limitLower=@limitLower,limitUpper=@limitUpper,operateTime=@operateTime WHERE DATEDIFF(DAY,currentDate,@insertDate)=0 AND accId=@accId AND gid=@gid AND gsId IS NULL; ");
strSql.Append(" end");
strSql.Append(" else");
strSql.Append(" begin");
strSql.Append(" INSERT INTO [Sys_I200].[dbo].T_SingleGoodsWaring(currentDate,accid,userRealName,alertStatus,alertTime,isWeb,isSms,isMob,isEmail,gid,gsId,gName,gQuantity,limitLower,limitUpper,warningType,isExtend,remark,operateTime) VALUES(@currentDate,@accId,@userRealName,@alertStatus,@alertTime,@isWeb,@isSms,@isMob,@isEmail,@gid,@gsId,@gName,@gQuantity,@limitLower,@limitUpper,@warningType,@isExtend,@remark,@operateTime);");
strSql.Append(" end");
var result = CommonHelpers.DapperHelper.Execute(strSql.ToString(),
new
{
currentDate = DateTime.Now.AddDays(-1).Date,
accId = goodInfo.AccId,
insertDate = DateTime.Now.AddDays(-1).Date,
userRealName = stockalertInfo.UserRealName,
alertStatus = stockalertInfo.AlertStatus,
alertTime = stockalertInfo.AlertTime,
isWeb = stockalertInfo.IsWeb,
isSms = stockalertInfo.IsSms,
isMob = stockalertInfo.IsMob,
isEmail = stockalertInfo.IsEmail,
gid = goodInfo.Gid,
gsId = goodInfo.Gsid,
gName = goodInfo.GName,
gQuantity = goodInfo.GQuantity,
limitLower = goodInfo.LimitLower,
limitUpper = goodInfo.LimitUpper,
warningType = goodInfo.WarningType,
isExtend = goodInfo.IsExtend,
remark = "",
operateTime = DateTime.Now
});
return(result);
}
