/// <summary> /// 更新数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> public bool Update(Inv_Movement model,bool IsValid) { bool result = false; if(IsValid){ int _rseult = instance.Update(model); if (_rseult > 0) { result = true; } } return result; }
/// <summary> /// 插入数据 /// </summary> /// <param name='model'>实体</param> /// <param name='model'>是否完成验证</param> /// <returns>bool</returns> public bool Insert(Inv_Movement model,bool IsValid) { bool result = false; if (IsValid) { //完成了验证,开始更新数据库了 int _result = instance.Add(model); if (_result > 0) { result = true; } } return result; }
/// <summary> /// 插入数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> public bool Insert(Inv_Movement model) { bool result = false; try { model.AuditStat = OperationTypeEnum.AudtiOperaTypeEnum.Auditing.ToString(); Verify_TemplateConfig vt = auditInstance.GetVerifyTemplateFirstNode(OperationTypeEnum.AuditTemplateEnum.ReturnDoc_R001.ToString()); if (vt != null) { model.AuditCurAudit = vt.VT_VerifyNode_Code; } int _result = instance.Add(model); if (_result > 0) { result = true; } } catch (Exception ex) { throw ex; } return result; }
/// <summary> /// 获取实体数据 /// </summary> /// <param name='strCondition'>条件(AND Code='11')</param> /// <returns>model</returns> public Inv_Movement GetModel(string strCondition) { List<Inv_Movement> list = instance.GetListByWhere(strCondition); Inv_Movement model = new Inv_Movement(); if (list != null && list.Count > 0) { model = list[0]; } else { model = null; } return model; }
/// <summary> /// 更新库存信息(更新库存信息表,添加库存移动信息表(出库) /// </summary> /// <param name="iInfo"></param> /// <returns></returns> public int UpdateInvInfo(Inv_Information iInfo) { iInfo.IInfor_Num = iInfo.IInfor_Num == 0 ? 0 : iInfo.IInfor_Num - 1; iInfo.IInfor_Stat = QX.Common.C_Class.OperationTypeEnum.InvStatEnum.Outing.ToString(); //两个表(移动 和 信息表)信息的更新 Inv_Movement mv = new Inv_Movement(); mv.MV_Code = GenerateMovCode(); mv.MV_PartNo = iInfo.IInfor_PartNo; mv.MV_PartName = iInfo.IInfor_PartName; mv.MV_ProdCode = iInfo.IInfor_ProdCode; mv.MV_Owner = iInfo.IInfor_OutPep; mv.MV_Date = iInfo.IInfor_OutDate; mv.MV_Type = OperationTypeEnum.InvStatEnum.Outing.ToString(); //增加一条产品移动信息 int re1 = mvInstance.Add(mv); //更新库存信息表记录 int re2 = Instance.Update(iInfo); if (re1 > 0 && re2 > 0) { return 1; } else { return 0; } }
/// <summary> /// 入库操作 /// </summary> /// <param name="iInfo"></param> /// <returns></returns> public int InventoryInvInfo(Inv_Information iInfo) { iInfo.IInfor_Num = 1; iInfo.IInfor_Stat = QX.Common.C_Class.OperationTypeEnum.InvStatEnum.Prod.ToString(); //入库时间--》编制时间 iInfo.IInfor_InDate = DateTime.Now; //用户编码 //iInfo.IInfor_InConfirm = SessionConfig.UserCode; //iInfo.IInfor_InDate = DateTime.Now; //两个表(移动 和 信息表)信息的更新 Inv_Movement mv = new Inv_Movement(); mv.MV_Code = GenerateMovCode(); mv.MV_PartNo = iInfo.IInfor_PartNo; mv.MV_PartName = iInfo.IInfor_PartName; mv.MV_ProdCode = iInfo.IInfor_ProdCode; mv.MV_Owner = iInfo.IInfor_InPep; mv.MV_Date = iInfo.IInfor_InDate; mv.CreateTime = DateTime.Now; mv.UpdateTime = DateTime.Now; mv.MV_Type = OperationTypeEnum.InvStatEnum.Prod.ToString(); //增加一条产品移动信息 int re1 = mvInstance.Add(mv); //更新库存信息表记录 int re2 = Instance.Update(iInfo); if (re1 > 0 && re2 > 0) { return 1; } else { return 0; } }