//作废
public BaseResult Invalid(Tb_Sp_Sku_Push info)
{
BaseResult br = new BaseResult();
var param = new Hashtable();
param.Add("id", info.id);
param.Add("new_falg_state", info.falg_state);
param.Add("new_id_sh", info.id_sh);
param.Add("new_rq_sh", DateTime.Now);
DAL.UpdatePart(typeof(Tb_Sp_Sku_Push), param);
br.Message.Add("商品已【作废】成功！");
br.Success = true;
return(br);
}
public ActionResult Check()
{
BaseResult br = new BaseResult();
try
{
var param = GetParameters();
if (!param.ContainsKey("checkState"))
{
br.Message.Add("非法提交！");
br.Level = ErrorLevel.Error;
br.Success = false;
return(Json(br));
}
else
{
int checkState = Convert.ToInt32(param["checkState"]);
var info = new Tb_Sp_Sku_Push
{
id = new Guid(param["id"].ToString()),
id_sh = GetLoginInfo <long?>("id_user")
};
if (checkState == 1)
{
if (param["fl"] == null)
{
br.Message.Add("商品类别不能为空！");
br.Level = ErrorLevel.Warning;
br.Success = false;
return(Json(br));
}
if (param["bm"] == null)
{
br.Message.Add("商品编码不能为空！");
br.Level = ErrorLevel.Warning;
br.Success = false;
return(Json(br));
}
if (param["dhs"] == null)
{
br.Message.Add("最小订货数不能为空！");
br.Level = ErrorLevel.Warning;
br.Success = false;
return(Json(br));
}
if (param["dhj"] == null)
{
br.Message.Add("订货价不能为空！");
br.Level = ErrorLevel.Warning;
br.Success = false;
return(Json(br));
}
info.id_spfl = long.Parse(param["fl"].ToString());
info.bm_Interface = param["bm"].ToString();
info.sl_dh_min = decimal.Parse(param["dhs"].ToString());
info.dj_dh = decimal.Parse(param["dhj"].ToString());
info.falg_state = (short?)GoodsRecommendFlag.Pass;
br = BusinessFactory.GoodsRecommend.Pass(info);
}
else if (checkState == 2)
{
//审核不通过
var nopass = param["nopass"];
if (nopass == null || string.IsNullOrEmpty(nopass.ToString().Trim()))
{
br.Message.Add("【不通过】意见不能为空！");
br.Success = false;
br.Level = ErrorLevel.Warning;
return(Json(br));
}
info.refusereason = param["nopass"].ToString().Trim();
info.falg_state = (short)GoodsRecommendFlag.NoPass;
br = BusinessFactory.GoodsRecommend.NoPass(info);
}
else if (checkState == 3)
{
info.falg_state = (short)GoodsRecommendFlag.invalid;
br = BusinessFactory.GoodsRecommend.Invalid(info);
}
}
}
catch (CySoftException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
return(Json(br));
}
public BaseResult Pass(Tb_Sp_Sku_Push info)
{
BaseResult br = new BaseResult();
var param = new Hashtable();
var now = DateTime.Now;
param.Add("id", info.id);
var pushInfo = DAL.GetItem <SpSkuPushData>(typeof(Tb_Sp_Sku_Push), param);
if (pushInfo == null)
{
br.Message.Add("推荐商品信息丢失！");
br.Success = false;
return(br);
}
//判断输入的商品编码是否重复
param.Clear();
param.Add("id_gys", pushInfo.id_gys);
param.Add("bm_Interface", info.bm_Interface);
if (DAL.GetCount(typeof(Tb_Gys_Sp), param) > 0)
{
br.Success = false;
br.Data = "bm";
br.Message.Add(string.Format("商品编码[{0}]重复,请重新输入商品编码", info.bm_Interface));
throw new CySoftException(br);
}
//判断当前商品是否已在分单表中
param.Clear();
param.Add("id_gys_fd", pushInfo.id_gys_push);
param.Add("id_sku", pushInfo.id_sku);
var spFdInfo = DAL.GetCount(typeof(Tb_sp_sku_fd), param);
if (spFdInfo > 0)
{
br.Message.Add("该商品已被推荐或应用，请选择其它商品审核！");
br.Success = false;
return(br);
}
param.Clear();
param.Add("id_gys", pushInfo.id_gys);
param.Add("id_sku", pushInfo.id_sku);
//获取当前商品信息 判断是否已存在该供应商的列表中
var spInfo = DAL.GetCount(typeof(Tb_Gys_Sp), param);
if (spInfo > 0)
{
br.Message.Add("该商品已存在列表！");
br.Success = false;
return(br);
}
//将商品存为自己的商品
DAL.Add <Tb_Gys_Sp>(new Tb_Gys_Sp()
{
id_gys = pushInfo.id_gys,
id_sku = pushInfo.id_sku,
id_sp = pushInfo.id_sp,
id_spfl = info.id_spfl,
flag_stop = 0,
bm_Interface = info.bm_Interface,
dj_base = info.dj_dh,
sort_id = 0,
zhl = pushInfo.zhl,
flag_up = YesNoFlag.Yes,
sl_kc = 0,
sl_kc_bj = 0,
id_create = info.id_sh,
rq_create = now,
id_edit = info.id_sh,
rq_edit = now
});
param.Clear();
param.Add("id_gys", pushInfo.id_gys);
//插入新的定价
var levelList = DAL.QueryList <Tb_Cgs_Level>(typeof(Tb_Cgs_Level), param);
var tb_sp_dj_list = levelList.Select(d => new Tb_Sp_Dj
{
id_gys = pushInfo.id_gys,
id_sku = pushInfo.id_sku,
id_cgs_level = d.id,
id_sp = pushInfo.id_sp,
sl_dh_min = info.sl_dh_min,
dj_dh = info.dj_dh * d.agio / 100,
id_create = info.id_sh,
rq_create = now,
id_edit = info.id_sh,
rq_edit = now
}).ToList();
DAL.AddRange <Tb_Sp_Dj>(tb_sp_dj_list);
//分单表插入关系
DAL.Add <Tb_sp_sku_fd>(new Tb_sp_sku_fd()
{
id = Guid.NewGuid(),
id_sku = pushInfo.id_sku,
id_gys_fd = pushInfo.id_gys_push,
id_gys = pushInfo.id_gys,
rq_create = now
});
//更新推荐商品的信息
param.Clear();
param.Add("id", info.id);
param.Add("new_id_spfl", info.id_spfl);
param.Add("new_bm_Interface", info.bm_Interface);
param.Add("new_sl_dh_min", info.sl_dh_min);
param.Add("new_dj_dh", info.dj_dh);
param.Add("new_id_sh", info.id_sh);
param.Add("new_rq_sh", now);
param.Add("new_falg_state", info.falg_state);
DAL.UpdatePart(typeof(Tb_Sp_Sku_Push), param);
br.Message.Add("商品已审核【通过】成功！");
br.Success = true;
return(br);
}
