/// <summary> /// 转换实体 /// </summary> /// <param name="whIOMain"></param> /// <returns></returns> public static RefData ChangeIOMainToRefData(WH_IOMain p) { return(new RefData { PUM_TypeDescription = "出库相关单据", PUM_TechType = "IA", PUM_Type = p.WHIOM_Type, PUM_Code = p.WHIOM_Code, PUM_RDate = p.WHIOM_RDate , PUM_IDate = p.WHIOM_IDate , PUM_PDate = p.WHIOM_PDate , PUM_BOwner = p.WHIOM_BOwner , PUM_Owner = p.WHIOM_Owner , PUM_Tranfee = p.WHIOM_TranFee, PUM_Tax = p.WHIOM_Tax, PUM_Discount = p.WHIOM_DisCount, PUM_DisSum = p.WHIOM_DisSum, PUM_RefType = p.WHIOM_RefType, PUM_RefCode = p.WHIOM_RefCode, PUM_Title = p.WHIOM_Title }); }
/// <summary> /// 更新数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> public bool Update(WH_IOMain model) { bool result = false; var e = new ModelExceptions(); int _rseult = instance.Update(model); if (_rseult > 0) { result = true; } return(result); }
/// <summary> /// 获取实体数据 /// </summary> /// <param name='strCondition'>条件(AND Code='11')</param> /// <returns>model</returns> public WH_IOMain GetModel(string strCondition) { List <WH_IOMain> list = instance.GetListByWhere(strCondition); WH_IOMain model = new WH_IOMain(); if (list != null && list.Count > 0) { model = list[0]; } else { model = null; } return(model); }
/// <summary> /// 插入数据 /// </summary> /// <param name='model'>实体</param> /// <param name='model'>是否完成验证</param> /// <returns>bool</returns> public bool Insert(WH_IOMain model, bool IsValid) { var e = new ModelExceptions(); bool result = false; if (e.IsValid && IsValid) { //完成了验证,开始更新数据库了 int _result = instance.Add(model); if (_result > 0) { result = true; } } return(result); }
/// <summary> /// 逻辑删除数据 /// </summary> /// <param name='model'>model</param> /// <returns>bool</returns> public bool Delete(string Condition) { bool result = false; List <WH_IOMain> list = instance.GetListByWhere(Condition); if (list.Count > 0) { WH_IOMain model = list[0]; model.Stat = 1; int _rseult = instance.Update(model); if (_rseult > 0) { result = true; } } return(result); }
/// <summary> /// 插入数据 /// </summary> /// <param name='model'>实体</param> /// <returns>bool</returns> public bool Insert(WH_IOMain model) { bool result = false; try { 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 WH_IOMain GetModel(int id) { WH_IOMain model = instance.GetByKey(id); return(model); }
/// <summary> /// 打印领料单 /// </summary> /// <param name="main"></param> /// <param name="list"></param> public void SendIOPrint(WH_IOMain main, IEnumerable <WH_IOItem> list) { string path = HttpContext.Current.Server.MapPath("~/CrReport/Rpt_Ticket_Picking.rpt"); AsyncCallback callback = delegate { ReportDocument rptDocument = new ReportDocument(); rptDocument.Load(path); QX.BLL.Bll_Comm comInstance = new QX.BLL.Bll_Comm(); //ParameterDiscreteValue crParameterDiscreteValue; //ParameterField crParameterField; //ParameterFields crParameterFields; //crParameterFields = new ParameterFields(); ////工程名称 //crParameterDiscreteValue = new ParameterDiscreteValue(); //crParameterDiscreteValue.Value = main.WHIOM_Code; //crParameterField = new ParameterField(); //crParameterField.ParameterFieldName = "WHIOM_Code"; //crParameterField.CurrentValues.Add(crParameterDiscreteValue); //crParameterFields.Add(crParameterField); ////工程名称 //crParameterDiscreteValue = new ParameterDiscreteValue(); //crParameterDiscreteValue.Value = main.WHIOM_RDate; //crParameterField = new ParameterField(); //crParameterField.ParameterFieldName = "WHIOM_RDate"; //crParameterField.CurrentValues.Add(crParameterDiscreteValue); //crParameterFields.Add(crParameterField); ////工程名称 //crParameterDiscreteValue = new ParameterDiscreteValue(); //crParameterDiscreteValue.Value = main.WHIOM_Department; //crParameterField = new ParameterField(); //crParameterField.ParameterFieldName = "WHIOM_Code"; //crParameterField.CurrentValues.Add(crParameterDiscreteValue); //crParameterFields.Add(crParameterField); ////工程名称 //crParameterDiscreteValue = new ParameterDiscreteValue(); //crParameterDiscreteValue.Value = main.WHIOM_Owner; //crParameterField = new ParameterField(); //crParameterField.ParameterFieldName = "WHIOM_Owner"; //crParameterField.CurrentValues.Add(crParameterDiscreteValue); //crParameterFields.Add(crParameterField); //crParameterDiscreteValue = new ParameterDiscreteValue(); //crParameterDiscreteValue.Value = main.WHIOM_BOwner; //crParameterField = new ParameterField(); //crParameterField.ParameterFieldName = "WHIOM_BOwner"; //crParameterField.CurrentValues.Add(crParameterDiscreteValue); //crParameterFields.Add(crParameterField); ////foreach (ParameterField p in crParameterFields) ////{ //// rptDocument.SetParameterValue(p.ParameterFieldName, p.CurrentValues[0]); ////} System.Data.DataTable dt = new System.Data.DataTable(); dt = comInstance.ListViewData(string.Format("select * from VRpt_IOItem where WHIOI_MainCode='{0}'", main.WHIOM_Code)); rptDocument.SetDataSource(list); rptDocument.SetParameterValue("WHIOM_Department", main.WHIOM_Department); rptDocument.SetParameterValue("WHIOM_Code", main.WHIOM_Code); rptDocument.SetParameterValue("WHIOM_Owner", main.WHIOM_Owner); rptDocument.SetParameterValue("WHIOM_BOwner", main.WHIOM_BOwner); rptDocument.SetParameterValue("WHIOM_RDate", main.WHIOM_RDate); rptDocument.PrintToPrinter(1, false, 0, 0); //开始打印所有页 }; callback.BeginInvoke(null, null, null); }