/// <summary> /// 取消结单 /// </summary> /// <param name="OrderNO">单据编号</param> /// <param name="strMsg">操作返回的信息</param> /// <returns></returns> public static bool UnCloseOrder(string OrderNO, out string strMsg) { string strElement = string.Empty; bool isSucc = false;//是否添加成功 //定义变量 string remark = string.Empty; //操作名称 strElement = ConstUtil.LOG_PROCESS_CONCELCOMPLETE; strMsg = ""; try { isSucc = SellPlanDBHelper.UnCloseOrder(OrderNO, out strMsg); //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } catch (Exception ex) { //输出日志 SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, "2031001"); //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } //写入日志 SellLogCommon.InsertLog(OrderNO, "2031001", "officedba.SellPlan", remark, strElement); return(isSucc); }
/// <summary> /// 删除单据 /// </summary> /// <param name="orderNos"></param> /// <returns></returns> public static bool DelOrder(string orderNos, out string strMsg, out string strFieldText) { bool isSucc = false;//是否添加成功 //定义变量 string remark = string.Empty; strFieldText = ""; strMsg = ""; try { isSucc = SellPlanDBHelper.DelOrder(orderNos, out strMsg, out strFieldText); //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } catch (Exception ex) { //输出日志 SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, "2031002"); //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } string[] orderNoS = null; orderNoS = orderNos.Split(','); for (int i = 0; i < orderNoS.Length; i++) { SellLogCommon.InsertLog(orderNoS[i], "2031002", "officedba.SellPlan", remark, ConstUtil.LOG_PROCESS_DELETE); } return(isSucc); }
/// <summary> ///总结计划 /// </summary> /// <returns></returns> public static bool SummarizeOrder(SellPlanDetailModel model, out string strMsg) { bool isSucc = false;//是否添加成功 //定义变量 string remark = string.Empty; strMsg = ""; try { isSucc = SellPlanDBHelper.SummarizeOrder(model, out strMsg); //设置操作成功标识 remark = "总结成功"; } catch (Exception ex) { //输出日志 SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, "2031001"); //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } SellLogCommon.InsertLog(model.PlanNo, "2031001", "officedba.SellPlanDetail", remark, ConstUtil.LOG_PROCESS_UPDATE); return(isSucc); }
/// <summary> /// 更新销售发货单 /// </summary> /// <returns></returns> public static bool Update(Hashtable ht, SellPlanModel sellPlanModel, SellPlanDetailModel sellPlanDetail, string strDetailAction, out string strMsg) { bool isSucc = false;//是否添加成功 //定义变量 string remark = string.Empty; strMsg = ""; try { isSucc = SellPlanDBHelper.Update(ht, sellPlanModel, sellPlanDetail, strDetailAction, out strMsg); //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } catch (Exception ex) { //输出日志 SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, "2031001"); //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } SellLogCommon.InsertLog(sellPlanModel.PlanNo, "2031001", "officedba.SellPlan", remark, ConstUtil.LOG_PROCESS_UPDATE); return(isSucc); }
/// <summary> /// 打印主表数据 /// </summary> /// <param name="OrderNo"></param> /// <returns></returns> public static DataTable GetRepOrder(string OrderNo) { return(SellPlanDBHelper.GetRepOrder(OrderNo)); }
/// <summary> /// 获取单据主表信息 /// </summary> /// <param name="orderID"></param> /// <returns></returns> public static DataTable GetOrderInfo(int orderID) { return(SellPlanDBHelper.GetOrderInfo(orderID)); }
/// <summary> /// 获取单据明细信息 /// </summary> /// <param name="orderNo"></param> /// <returns></returns> public static DataTable GetOrderDetail(string orderNo) { return(SellPlanDBHelper.GetOrderDetail(orderNo)); }
/// <summary> /// 获取单据列表 /// </summary> /// <param name="sellOfferModel">sellOfferModel表实体</param> /// <param name="FlowStatus">审批状态</param> /// <returns></returns> public static DataTable GetOrderList(string EFIndex, string EFDesc, SellPlanModel sellPlanModel, int?FlowStatus, int pageIndex, int pageCount, string ord, ref int TotalCount) { return(SellPlanDBHelper.GetOrderList(EFIndex, EFDesc, sellPlanModel, FlowStatus, pageIndex, pageCount, ord, ref TotalCount)); }
/// <summary> /// 获取当前单据的id /// </summary> /// <param name="orderNo"></param> /// <returns></returns> public static int GetOrderID(string orderNo) { return(SellPlanDBHelper.GetOrderID(orderNo)); }