コード例 #1
0
ファイル: OrderInfoBLL.cs プロジェクト: lovenets/PMS
        /// <summary>
        /// 带分页查询
        /// </summary>
        /// <param name="ID">订购主键</param>
        /// <param name="BKDH">报刊代号</param>
        /// <param name="OrderNo">单位编号</param>
        /// <param name="unitname">单位名称</param>
        /// <param name="dt1">录入时间</param>
        /// <param name="dt2">录入时间</param>
        /// <param name="pageLimit"></param>
        /// <param name="pageIndex"></param>
        /// <returns></returns>
        public PageModel GetOrderInfo(int ID, string BKDH, string OrderNo, string unitname, string dt1, string dt2, string orgid, string chooseorg, string OrderState, string CostState, int pageLimit = 1, int pageIndex = 0, bool istj = false)
        {
            PageModel pg = new PageModel();

            try
            {
                DataTable dt = dal.GetOrderInfo(ID, BKDH, OrderNo, unitname, dt1, dt2,
                                                pageLimit, pageIndex, orgid, chooseorg, OrderState, CostState);
                if (dt.Rows.Count > 0 && dt != null)
                {
                    DataTable tj = dal.GetCount(ID, BKDH, OrderNo, unitname, dt1, dt2, orgid,
                                                chooseorg, OrderState, CostState);
                    pg.code  = 0;
                    pg.msg   = "";
                    pg.count = tj.Rows[0]["num"]._ToInt32();
                    pg.data  = dt;
                    pg.msg   = "总订购月数:" + tj.Rows[0]["OrderMonths"]._ToInt32() + ",总订购份数:" + tj.Rows[0]["OrderNum"]._ToInt32() + ",总价:" + tj.Rows[0]["Money"]._ToInt32() + ",已缴费用:" + tj.Rows[0]["MoneyPayed"]._ToInt32();
                }
                else
                {
                    pg.code  = 1;
                    pg.msg   = "未查询到数据";
                    pg.count = 0;
                    pg.data  = dt;
                }
            }
            catch (Exception ex)
            {
                pg.code = 1;
                pg.msg  = ex.Message;
            }
            return(pg);
        }
コード例 #2
0
 public OrderInfo GetOrderInfo(int orderId)
 {
     return(odDal.GetOrderInfo(orderId));
 }