/// <summary> /// 修改耗材信息 /// </summary> /// <param name="info">耗材信息</param> /// <returns>耗材id</returns> public int UpdateConsumable(InvConsumableInfo info) { sqlStr = "UPDATE tblInvConsumable Set ConsumableID=@ConsumableID,LotNum=@LotNum,Specification=@Specification, " + " Model=@Model,SupplierID=@SupplierID,Price=@Price,ReceiveQty=@ReceiveQty,PurchaseDate=@PurchaseDate," + " PurchaseID=@PurchaseID,Comments=@Comments,AvaibleQty=@AvaibleQty,UpdateDate=GetDate() " + " WHERE ID = @ID"; using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr)) { command.Parameters.Add("@ID", SqlDbType.Int).Value = info.ID; command.Parameters.Add("@ConsumableID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.Consumable.ID); command.Parameters.Add("@LotNum", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.LotNum); command.Parameters.Add("@Specification", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Specification); command.Parameters.Add("@Model", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Model); command.Parameters.Add("@SupplierID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.Supplier.ID); command.Parameters.Add("@Price", SqlDbType.Decimal).Value = info.Price; command.Parameters.Add("@ReceiveQty", SqlDbType.Decimal).Value = info.ReceiveQty; command.Parameters.Add("@PurchaseDate", SqlDbType.DateTime).Value = SQLUtil.ConvertDateTime(info.PurchaseDate); command.Parameters.Add("@PurchaseID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.Purchase.ID); command.Parameters.Add("@AvaibleQty", SqlDbType.Decimal).Value = info.AvaibleQty; command.Parameters.Add("@Comments", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Comments); command.ExecuteNonQuery(); return(info.ID); } }
public JsonResult SaveConsumable(int userID, string sessionID, InvConsumableInfo info) { ServiceResultModel <int> result = new ServiceResultModel <int>(); try { if (!CheckSessionID(userID, sessionID, result)) { return(MyJson(result, JsonRequestBehavior.AllowGet)); } UserInfo user = null; if (CheckUser(userID, result, out user) == false) { return(MyJson(result, JsonRequestBehavior.AllowGet)); } if (this.invConsumableDao.CheckConsumableLotNum(info.ID, info.LotNum, info.Consumable.ID)) { result.SetFailed(ResultCodes.ParameterError, "批次号已存在"); return(MyJson(result, JsonRequestBehavior.AllowGet)); } result.Data = this.invConsumableManager.SaveConsumable(info, user); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(MyJson(result, JsonRequestBehavior.AllowGet)); }
public int SaveConsumable(InvConsumableInfo info, UserInfo userInfo) { if (info.ID == 0) { info.ID = this.invConsumableDao.AddConsumable(info); } else { this.invConsumableDao.UpdateConsumable(info); } return(info.ID); }
/// <summary> /// 添加采购单耗材 /// </summary> /// <param name="purchaseOrderID">采购单id</param> /// <param name="consumableID">耗材id</param> public void AddConsumable(int purchaseOrderID, InvConsumableInfo consumableInfo) { sqlStr = "INSERT INTO tblPurchaseConsumable (PurchaseID,ConsumableID,Specification,Model,Price,Qty,InboundQty) " + " VALUES(@PurchaseID,@ConsumableID,@Specification,@Model,@Price,@Qty,0); "; using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr)) { command.Parameters.Add("@PurchaseID", SqlDbType.Int).Value = purchaseOrderID; command.Parameters.Add("@ConsumableID", SqlDbType.Int).Value = consumableInfo.Consumable.ID; command.Parameters.Add("@Specification", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(consumableInfo.Specification); command.Parameters.Add("@Model", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(consumableInfo.Model); command.Parameters.Add("@Price", SqlDbType.Decimal).Value = consumableInfo.Price; command.Parameters.Add("@Qty", SqlDbType.Decimal).Value = consumableInfo.Qty; command.ExecuteNonQuery(); } }
public JsonResult SaveConsumable(InvConsumableInfo info) { ResultModel <int> result = new ResultModel <int>(); if (CheckSession(false) == false) { return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet)); } if (CheckSessionID() == false) { return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet)); } try { result.Data = this.invConsumableManager.SaveConsumable(info, GetLoginUser()); } catch (Exception ex) { NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message); result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage); } return(JsonResult(result)); }
/// <summary> /// 添加耗材 /// </summary> /// <param name="info">耗材信息</param> /// <returns>耗材id</returns> public int AddConsumable(InvConsumableInfo info) { sqlStr = "INSERT INTO tblInvConsumable(ConsumableID,LotNum,Specification,Model,SupplierID,Price,ReceiveQty,PurchaseDate,PurchaseID,AvaibleQty,Comments,AddDate) " + " VALUES(@ConsumableID,@LotNum,@Specification,@Model,@SupplierID,@Price,@ReceiveQty,@PurchaseDate,@PurchaseID,@ReceiveQty,@Comments,GetDate()); " + " SELECT @@IDENTITY "; using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr)) { command.Parameters.Add("@ConsumableID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.Consumable.ID); command.Parameters.Add("@LotNum", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.LotNum); command.Parameters.Add("@Specification", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Specification); command.Parameters.Add("@Model", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Model); command.Parameters.Add("@SupplierID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.Supplier.ID); command.Parameters.Add("@Price", SqlDbType.Decimal).Value = info.Price; command.Parameters.Add("@ReceiveQty", SqlDbType.Decimal).Value = info.ReceiveQty; command.Parameters.Add("@PurchaseDate", SqlDbType.DateTime).Value = SQLUtil.ConvertDateTime(info.PurchaseDate); command.Parameters.Add("@PurchaseID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.Purchase.ID); command.Parameters.Add("@Comments", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.Comments); info.ID = SQLUtil.ConvertInt(command.ExecuteScalar()); return(info.ID); } }