/// <summary> /// 添加进货 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool SaveInStorage(ST_InStorage model) { model.EntityState = EntityState.Added; var sqlStr = new StringBuilder(); sqlStr.Append(" UPDATE [ST_Shops] SET S_SumNum+=" + model.I_NUM + ",S_SumPrice+=" + model.I_SUMPRICE + ",S_InDate=getdate() where ID=" + model.I_SHOPSID); return(DBHelper.Save(model, new List <string> { sqlStr.ToString() }).ResultStatus); }
/// <summary> /// 添加进货 /// </summary> /// <param name="shopsId"></param> /// <returns></returns> public ActionResult AddInStorage(string shopsId) { var item = St_LogicHelper.GetShopsById(shopsId); if (item == null) { return(null); } var model = new ST_InStorage() { I_SHOPSID = item.ID, I_PRICE = item.S_INPRICE }; return(View(model)); }
public JsonResult SaveInStorage(ST_InStorage inStorage) { var result = new JsonResult(); if (inStorage == null) { result.Data = "获取进货信息失败"; } else { inStorage.I_ADDTIME = DateTime.Now; inStorage.I_ADDUSER = ((ST_SysAdmin)Session["sysAdmin"]).UserName; inStorage.I_SUMPRICE = inStorage.I_NUM * inStorage.I_PRICE; if (St_LogicHelper.SaveInStorage(inStorage)) { result.Data = "success"; } else { result.Data = "进货信息保存失败"; } } return(result); }