コード例 #1
0
        public ActionResult AutoGetUnitList(string query)
        {
            LiquidateEntity _liquidateEntity = new LiquidateEntity();
            _liquidateEntity.LiquidateDBEntity = new List<LiquidateDBEntity>();
            LiquidateDBEntity liquidateDBEntity = new LiquidateDBEntity();
            liquidateDBEntity.AutoQuery = query;

            _liquidateEntity.LiquidateDBEntity.Add(liquidateDBEntity);
            DataSet dsResult = LiquidateInfoBP.CommonSelect(_liquidateEntity).QueryResult;

            query = query.Replace(" ", "");
            if (query.Length > 1)
            {
                int op = query.LastIndexOf(",");
                query = query.Substring(op + 1);
            }

            ArrayList alCity = new ArrayList();

            for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++ )
            {
                alCity.Add(dsResult.Tables[0].Rows[i][0].ToString().Trim());
            }
            return Json(alCity, JsonRequestBehavior.AllowGet);
        }
コード例 #2
0
        /// <summary>
        /// 确认清算报表
        /// </summary>
        /// <param name="liquidateEntity"></param>
        /// <returns></returns>
        public static LiquidateEntity ApproveLiquidate(LiquidateEntity liquidateEntity)
        {
            //liquidateEntity.LogMessages.MsgType = MessageType.INFO;
            //liquidateEntity.LogMessages.Content = _nameSpaceClass + "Select";
            //LoggerHelper.LogWriter(liquidateEntity.LogMessages);

            try
            {
                return LiquidateDA.ApproveLiquidate(liquidateEntity);
            }
            catch (Exception ex)
            {
                //liquidateEntity.LogMessages.MsgType = MessageType.ERROR;
                //liquidateEntity.LogMessages.Content = _nameSpaceClass + "Select  Error: " + ex.Message;
                //LoggerHelper.LogWriter(liquidateEntity.LogMessages);
                throw ex;
            }
        }
コード例 #3
0
        public static LiquidateEntity AddLiquidateAdjust(LiquidateEntity liquidateEntity)
        {
            LiquidateDBEntity dbParm = (liquidateEntity.LiquidateDBEntity.Count > 0) ? liquidateEntity.LiquidateDBEntity[0] : new LiquidateDBEntity();
            DataSet dsOrderInfo = new DataSet();
            if (!"1".Equals(dbParm.LiquidationType))
            {
                dsOrderInfo = GetOrderLiquidate(liquidateEntity).QueryResult;
                if (dsOrderInfo.Tables.Count == 0 || dsOrderInfo.Tables[0].Rows.Count == 0)
                {
                    liquidateEntity.Result = 0;
                    return liquidateEntity;
                }
            }
            DataCommand unitCmd = DataCommandManager.GetDataCommand("AddLiquidateAdjust");
            unitCmd.SetParameterValue("@SLID", dbParm.SLID);
            unitCmd.SetParameterValue("@LIQUIDATIONTYPE", dbParm.LiquidationType);
            unitCmd.SetParameterValue("@ADJUSTNM", dbParm.AdjustName);
            unitCmd.SetParameterValue("@SLAMOUNT", dbParm.SlAmount);
            unitCmd.SetParameterValue("@REMARK", dbParm.LiquidationRemark);

            unitCmd.SetParameterValue("@TOTALAMOUNT", (!"1".Equals(dbParm.LiquidationType)) ? dbParm.TotalAmount : "");
            unitCmd.SetParameterValue("@ORDERID", (!"1".Equals(dbParm.LiquidationType)) ? dbParm.OrderID : "");
            unitCmd.SetParameterValue("@CITYID", (!"1".Equals(dbParm.LiquidationType)) ? dsOrderInfo.Tables[0].Rows[0]["CITYID"].ToString() : "");
            unitCmd.SetParameterValue("@CITYNM", (!"1".Equals(dbParm.LiquidationType)) ? dsOrderInfo.Tables[0].Rows[0]["CITYNM"].ToString() : "");
            unitCmd.SetParameterValue("@HOTELID", (!"1".Equals(dbParm.LiquidationType)) ? dsOrderInfo.Tables[0].Rows[0]["HOTELID"].ToString() : "");
            unitCmd.SetParameterValue("@HOTELNM", (!"1".Equals(dbParm.LiquidationType)) ? dsOrderInfo.Tables[0].Rows[0]["HOTELNM"].ToString() : "");
            unitCmd.SetParameterValue("@GROUPID", (!"1".Equals(dbParm.LiquidationType)) ? dsOrderInfo.Tables[0].Rows[0]["GROUPID"].ToString() : "");
            unitCmd.SetParameterValue("@GROUPNM", (!"1".Equals(dbParm.LiquidationType)) ? dsOrderInfo.Tables[0].Rows[0]["GROUPNM"].ToString() : "");
            unitCmd.SetParameterValue("@ROOMID", (!"1".Equals(dbParm.LiquidationType)) ? dsOrderInfo.Tables[0].Rows[0]["ROOMID"].ToString() : "");
            unitCmd.SetParameterValue("@ROOMNM", (!"1".Equals(dbParm.LiquidationType)) ? dsOrderInfo.Tables[0].Rows[0]["ROOMNM"].ToString() : "");
            unitCmd.SetParameterValue("@ROOMNUM", (!"1".Equals(dbParm.LiquidationType)) ? dsOrderInfo.Tables[0].Rows[0]["ROOMNUM"].ToString() : "");
            unitCmd.SetParameterValue("@GUESTNM", (!"1".Equals(dbParm.LiquidationType)) ? dsOrderInfo.Tables[0].Rows[0]["GUESTNM"].ToString() : "");
            unitCmd.SetParameterValue("@INDATE", (!"1".Equals(dbParm.LiquidationType)) ? dsOrderInfo.Tables[0].Rows[0]["INDATE"].ToString() : "");
            unitCmd.SetParameterValue("@OUTDATE", (!"1".Equals(dbParm.LiquidationType)) ? dsOrderInfo.Tables[0].Rows[0]["OUTDATE"].ToString() : "");

            unitCmd.SetParameterValue("@ISNEXTMONTH", "0");
            unitCmd.SetParameterValue("@INTOMONTH", DBNull.Value);
            unitCmd.SetParameterValue("@NEXTTIMES", 0);
            unitCmd.SetParameterValue("@STATUS", "0");
            unitCmd.SetParameterValue("@CREATEUSER", liquidateEntity.LogMessages.Userid);
            liquidateEntity.Result = unitCmd.ExecuteNonQuery();
            return liquidateEntity;
        }
コード例 #4
0
        public static LiquidateEntity ApproveLiquidate(LiquidateEntity liquidateEntity)
        {
            LiquidateDBEntity dbParm = (liquidateEntity.LiquidateDBEntity.Count > 0) ? liquidateEntity.LiquidateDBEntity[0] : new LiquidateDBEntity();

            DataCommand unitCmd = DataCommandManager.GetDataCommand("ApproveLiquidate");
            unitCmd.SetParameterValue("@SLID", dbParm.SLID);
            unitCmd.SetParameterValue("@BillConfirmUser", dbParm.BillConfirmUser);
            unitCmd.SetParameterValue("@BillConfirmRemark", dbParm.BillConfirmRemark);
            unitCmd.SetParameterValue("@UnitRemark", dbParm.UnitRemark);
            unitCmd.SetParameterValue("@OPEUser", liquidateEntity.LogMessages.Userid);
            liquidateEntity.Result = unitCmd.ExecuteNonQuery();

            //OracleParameter[] parm ={
            //                         new OracleParameter("UnitID",OracleType.VarChar),
            //                         new OracleParameter("UnitRemark",OracleType.VarChar),
            //                         new OracleParameter("OPEUser",OracleType.VarChar)
            //                    };
            //parm[0].Value = dbParm.UnitID;
            //parm[1].Value = dbParm.UnitRemark;
            //parm[2].Value = liquidateEntity.LogMessages.Userid;
            //DbManager.ExecuteSql("SettleInfo", "t_lm_settlement_unit_remark_update", parm);

            return liquidateEntity;
        }
コード例 #5
0
        public string ActionAjxSettleMainList(int pagecurrent)
        {
            LiquidateEntity _liquidateEntity = new LiquidateEntity();
            _liquidateEntity.LiquidateDBEntity = new List<LiquidateDBEntity>();
            LiquidateDBEntity liquidateDBEntity = new LiquidateDBEntity();

            liquidateDBEntity.UnitID = ViewBag.QRUnitID;
            liquidateDBEntity.CityID = ViewBag.QRCity;
            liquidateDBEntity.UnitCharge = ViewBag.QRUnitcharge;
            liquidateDBEntity.SaveUser = ViewBag.QRSaveuser;
            liquidateDBEntity.OrderID = ViewBag.QROrderid;
            liquidateDBEntity.SlMonth = ViewBag.QRMonth;
            liquidateDBEntity.SlStatus = ViewBag.QRSlstatus;
            liquidateDBEntity.BillID = ViewBag.QRBillid;

            //liquidateDBEntity.UnitName = "";
            //liquidateDBEntity.HotelID = "";
            //liquidateDBEntity.HotelGroup = "";

            _liquidateEntity.LiquidateDBEntity.Add(liquidateDBEntity);
            _liquidateEntity.PageCurrent = pagecurrent - 1;
            //_liquidateEntity.PageSize = ViewBag.PageSize;

            _liquidateEntity = LiquidateInfoBP.GetLiquidateList(_liquidateEntity);
            DataSet dsResult = _liquidateEntity.QueryResult;

            using (var sw = new StringWriter())
            {
                ViewBag.Pagers = PagerControl.Pagers(pagecurrent, "fn_settle_main_research({0})", _liquidateEntity.TotalCount, _liquidateEntity.PageSize, _liquidateEntity.PageSplit);
                ViewData.Model = dsResult;
                var viewResult = ViewEngines.Engines.FindPartialView(ControllerContext, "../Partial/_settleMainListInfo");
                var viewContent = new ViewContext(ControllerContext, viewResult.View, ViewData, TempData, sw);
                viewResult.View.Render(viewContent, sw);
                return sw.GetStringBuilder().ToString();
            }
        }
コード例 #6
0
        public static LiquidateEntity AddLiquidateIssue(LiquidateEntity liquidateEntity)
        {
            LiquidateDBEntity dbParm = (liquidateEntity.LiquidateDBEntity.Count > 0) ? liquidateEntity.LiquidateDBEntity[0] : new LiquidateDBEntity();

            return liquidateEntity;
        }
コード例 #7
0
        public static LiquidateEntity MoveBackMonthAdjust(LiquidateEntity liquidateEntity)
        {
            LiquidateDBEntity dbParm = (liquidateEntity.LiquidateDBEntity.Count > 0) ? liquidateEntity.LiquidateDBEntity[0] : new LiquidateDBEntity();
            DataSet dsResult = GetOrderLiquidateDetail(liquidateEntity);
            DateTime dt = DateTime.Parse(dsResult.Tables[0].Rows[0]["INTOMONTH"].ToString().Trim()).AddMonths(-1);
            string strINTOMONTH = dt.ToString("yyyy-MM");

            // Check转入月未销账
            if (ChkIsOrderMonthApproved(dbParm.UnitID, strINTOMONTH))
            {
                liquidateEntity.Result = 2;
                return liquidateEntity;
            }

            // 转回当月需要判断月份是否小于账单月份。如果小于就不让再转回到当月前。
            // 首先判断转入月 - 1月 是否和该账单是同月,如果是:则是否转入更新为0 转入月和次数清空
            // 首先判断转入月 - 1月 与账单月不同:转入月就是该转入月-1月 次数为-1

            if (dsResult.Tables[0].Rows[0]["INTOMONTH"].ToString().Trim().Equals(strINTOMONTH))
            {
                dbParm.HsLiquidateOrder.Add("ISNEXTMONTH", "0");
                dbParm.HsLiquidateOrder.Add("INTOMONTH", "");
                dbParm.HsLiquidateOrder.Add("NEXTTIMES", 0);
            }
            else
            {
                dbParm.HsLiquidateOrder.Add("ISNEXTMONTH", "1");
                dbParm.HsLiquidateOrder.Add("INTOMONTH", strINTOMONTH);
                dbParm.HsLiquidateOrder.Add("NEXTTIMES", (String.IsNullOrEmpty(dsResult.Tables[0].Rows[0]["NEXTTIMES"].ToString().Trim()) ? 1 : int.Parse(dsResult.Tables[0].Rows[0]["NEXTTIMES"].ToString().Trim()) - 1));
            }

            DataCommand unitCmd = DataCommandManager.GetDataCommand("MoveMonthAdjust");
            unitCmd.SetParameterValue("@SLID", dbParm.SLID);
            unitCmd.SetParameterValue("@LIQUIDATIONID", dbParm.HsLiquidateOrder["LIQUIDATIONID"].ToString().Trim());
            unitCmd.SetParameterValue("@ISNEXTMONTH", dbParm.HsLiquidateOrder["ISNEXTMONTH"].ToString().Trim());
            unitCmd.SetParameterValue("@INTOMONTH", dbParm.HsLiquidateOrder["INTOMONTH"].ToString().Trim());
            unitCmd.SetParameterValue("@NEXTTIMES", dbParm.HsLiquidateOrder["NEXTTIMES"].ToString().Trim());
            unitCmd.SetParameterValue("@REMARK", dbParm.HsLiquidateOrder["REMARK"].ToString().Trim());
            unitCmd.SetParameterValue("@OPEUSER", liquidateEntity.LogMessages.Userid);
            liquidateEntity.Result = unitCmd.ExecuteNonQuery();
            return liquidateEntity;
        }
コード例 #8
0
        public static LiquidateEntity MoveNextMonthAdjust(LiquidateEntity liquidateEntity)
        {
            // 首先判断是否转移为0 是:是否转下月设置为1 转入月就是该张账单月+1月 次数为1
            // 首先判断是否转移为1 是:转入月就是该转入月+1月 次数为+1
            LiquidateDBEntity dbParm = (liquidateEntity.LiquidateDBEntity.Count > 0) ? liquidateEntity.LiquidateDBEntity[0] : new LiquidateDBEntity();
            DataSet dsResult = GetOrderLiquidateDetail(liquidateEntity);

            if (!"1".Equals(dsResult.Tables[0].Rows[0]["ISNEXTMONTH"].ToString().Trim()))
            {
                DateTime dt = DateTime.Parse(dsResult.Tables[0].Rows[0]["SLMONTH"].ToString().Trim()).AddMonths(1);
                dbParm.HsLiquidateOrder.Add("INTOMONTH", dt.ToString("yyyy-MM"));
                dbParm.HsLiquidateOrder.Add("NEXTTIMES", 1);
            }
            else
            {
                DateTime dt = DateTime.Parse(dsResult.Tables[0].Rows[0]["INTOMONTH"].ToString().Trim()).AddMonths(1);
                dbParm.HsLiquidateOrder.Add("INTOMONTH", dt.ToString("yyyy-MM"));
                dbParm.HsLiquidateOrder.Add("NEXTTIMES", (String.IsNullOrEmpty(dsResult.Tables[0].Rows[0]["NEXTTIMES"].ToString().Trim()) ? 1 : int.Parse(dsResult.Tables[0].Rows[0]["NEXTTIMES"].ToString().Trim()) + 1));
            }

            // Check转入月未销账
            if (ChkIsOrderMonthApproved(dbParm.UnitID, dbParm.HsLiquidateOrder["INTOMONTH"].ToString()))
            {
                liquidateEntity.Result = 2;
                return liquidateEntity;
            }

            DataCommand unitCmd = DataCommandManager.GetDataCommand("MoveMonthAdjust");
            unitCmd.SetParameterValue("@SLID", dbParm.SLID);
            unitCmd.SetParameterValue("@LIQUIDATIONID", dbParm.HsLiquidateOrder["LIQUIDATIONID"].ToString().Trim());
            unitCmd.SetParameterValue("@ISNEXTMONTH", "1");
            unitCmd.SetParameterValue("@INTOMONTH", dbParm.HsLiquidateOrder["INTOMONTH"].ToString().Trim());
            unitCmd.SetParameterValue("@NEXTTIMES", dbParm.HsLiquidateOrder["NEXTTIMES"].ToString().Trim());
            unitCmd.SetParameterValue("@REMARK", dbParm.HsLiquidateOrder["REMARK"].ToString().Trim());
            unitCmd.SetParameterValue("@OPEUSER", liquidateEntity.LogMessages.Userid);
            liquidateEntity.Result = unitCmd.ExecuteNonQuery();
            return liquidateEntity;
        }
コード例 #9
0
 public static DataSet GetOrderLiquidateDetail(LiquidateEntity liquidateEntity)
 {
     LiquidateDBEntity dbParm = (liquidateEntity.LiquidateDBEntity.Count > 0) ? liquidateEntity.LiquidateDBEntity[0] : new LiquidateDBEntity();
     DataCommand unitCmd = DataCommandManager.GetDataCommand("GetOrderLiquidateDetail");
     unitCmd.SetParameterValue("@SLID", dbParm.SLID);
     unitCmd.SetParameterValue("@LIQUIDATIONID", dbParm.HsLiquidateOrder["LIQUIDATIONID"].ToString().Trim());
     return unitCmd.ExecuteDataSet();
 }
コード例 #10
0
        public static LiquidateEntity ModifyLiquidateAdjust(LiquidateEntity liquidateEntity)
        {
            LiquidateDBEntity dbParm = (liquidateEntity.LiquidateDBEntity.Count > 0) ? liquidateEntity.LiquidateDBEntity[0] : new LiquidateDBEntity();

            DataCommand unitCmd = DataCommandManager.GetDataCommand("ModifyLiquidateAdjust");
            unitCmd.SetParameterValue("@SLID", dbParm.SLID);
            unitCmd.SetParameterValue("@LIQUIDATIONID", dbParm.HsLiquidateOrder["LIQUIDATIONID"].ToString().Trim());
            unitCmd.SetParameterValue("@HOTELID", dbParm.HsLiquidateOrder["HOTELID"].ToString().Trim());
            unitCmd.SetParameterValue("@HOTELNM", dbParm.HsLiquidateOrder["HOTELNM"].ToString().Trim());
            unitCmd.SetParameterValue("@ROOMID", dbParm.HsLiquidateOrder["ROOMID"].ToString().Trim());
            unitCmd.SetParameterValue("@ROOMNM", dbParm.HsLiquidateOrder["ROOMNM"].ToString().Trim());
            unitCmd.SetParameterValue("@ROOMNUM", dbParm.HsLiquidateOrder["ROOMNUM"].ToString().Trim());
            unitCmd.SetParameterValue("@GUESTNM", dbParm.HsLiquidateOrder["GUESTNM"].ToString().Trim());
            unitCmd.SetParameterValue("@INDATE", dbParm.HsLiquidateOrder["INDATE"].ToString().Trim());
            unitCmd.SetParameterValue("@OUTDATE", dbParm.HsLiquidateOrder["OUTDATE"].ToString().Trim());
            unitCmd.SetParameterValue("@TOTALAMOUNT", dbParm.HsLiquidateOrder["TOTALAMOUNT"].ToString().Trim());
            unitCmd.SetParameterValue("@SLAMOUNT", dbParm.HsLiquidateOrder["SLAMOUNT"].ToString().Trim());
            unitCmd.SetParameterValue("@REMARK", dbParm.HsLiquidateOrder["REMARK"].ToString().Trim());
            unitCmd.SetParameterValue("@OPEUSER", liquidateEntity.LogMessages.Userid);
            liquidateEntity.Result = unitCmd.ExecuteNonQuery();
            return liquidateEntity;
        }
コード例 #11
0
        public static LiquidateEntity GetLiquidateList(LiquidateEntity liquidateEntity)
        {
            LiquidateDBEntity dbParm = (liquidateEntity.LiquidateDBEntity.Count > 0) ? liquidateEntity.LiquidateDBEntity[0] : new LiquidateDBEntity();
            DataCommand cmd = DataCommandManager.GetDataCommand("GetLiquidateList");

            cmd.SetParameterValue("@UnitID", dbParm.UnitID);
            cmd.SetParameterValue("@UnitName", dbParm.UnitName);
            cmd.SetParameterValue("@HotelID", dbParm.HotelID);
            cmd.SetParameterValue("@HotelGroup", dbParm.HotelGroup);
            cmd.SetParameterValue("@CityID", dbParm.CityID);
            cmd.SetParameterValue("@UnitCharge", dbParm.UnitCharge);
            cmd.SetParameterValue("@SaveUser", dbParm.SaveUser);
            cmd.SetParameterValue("@OrderID", dbParm.OrderID);
            cmd.SetParameterValue("@SlMonth", dbParm.SlMonth);
            cmd.SetParameterValue("@SlStatus", dbParm.SlStatus);
            cmd.SetParameterValue("@BillID", dbParm.BillID);

            cmd.SetParameterValue("@PageCurrent", liquidateEntity.PageCurrent);
            cmd.SetParameterValue("@PageSize", liquidateEntity.PageSize);
            cmd.SetParameterValue("@SortField", liquidateEntity.SortField);
            cmd.SetParameterValue("@SortType", liquidateEntity.SortType);
            liquidateEntity.QueryResult = cmd.ExecuteDataSet();
            liquidateEntity.TotalCount = (int)cmd.GetParameterValue("@TotalCount");
            return liquidateEntity;
        }
コード例 #12
0
 public static LiquidateEntity GetOrderLiquidate(LiquidateEntity liquidateEntity)
 {
     LiquidateDBEntity dbParm = (liquidateEntity.LiquidateDBEntity.Count > 0) ? liquidateEntity.LiquidateDBEntity[0] : new LiquidateDBEntity();
     OracleParameter[] parm ={
                              new OracleParameter("OrderID",OracleType.VarChar)
                         };
     parm[0].Value = dbParm.OrderID;
     liquidateEntity.QueryResult = DbManager.Query("SettleInfo", "t_lm_settlement_order_select", true, parm);
     return liquidateEntity;
 }
コード例 #13
0
 public static LiquidateEntity FaxLiquidateList(LiquidateEntity liquidateEntity)
 {
     return liquidateEntity;
 }
コード例 #14
0
        public static LiquidateEntity GetLiquidateDetail(LiquidateEntity liquidateEntity)
        {
            LiquidateDBEntity dbParm = (liquidateEntity.LiquidateDBEntity.Count > 0) ? liquidateEntity.LiquidateDBEntity[0] : new LiquidateDBEntity();

            // 结算单详情 + 结算单位详情  结算单位是镜像已经保存在结算单内。
            DataCommand slCmd = DataCommandManager.GetDataCommand("GetSLDetial");
            slCmd.SetParameterValue("@SLID", dbParm.SLID);
            liquidateEntity.LiquidateDBEntity[0].DtSLDetial = slCmd.ExecuteDataSet().Tables[0].Copy();

            //DataCommand unitCmd = DataCommandManager.GetDataCommand("GetLiquidateUnitDetial");
            //unitCmd.SetParameterValue("@SLID", dbParm.UnitID);

            //OracleParameter[] parm ={
            //                         new OracleParameter("UnitID",OracleType.VarChar)
            //                    };
            //parm[0].Value = dbParm.UnitID;
            //DataSet dsResult = DbManager.Query("SettleInfo", "t_lm_settlement_unit_detail_select", true, parm);
            //liquidateEntity.LiquidateDBEntity[0].DtUnitDetial = dsResult.Tables[0].Copy();

            DataCommand monthCmd = DataCommandManager.GetDataCommand("GetLiquidateMonthOrder");
            monthCmd.SetParameterValue("@SLID", dbParm.SLID);
            liquidateEntity.LiquidateDBEntity[0].DtMonthOrder = monthCmd.ExecuteDataSet().Tables[0].Copy();

            DataCommand hisOrderCmd = DataCommandManager.GetDataCommand("GetLiquidateHisOrder");
            hisOrderCmd.SetParameterValue("@SLID", dbParm.SLID);
            hisOrderCmd.SetParameterValue("@UnitID", dbParm.UnitID);
            hisOrderCmd.SetParameterValue("@IntoMonth", dbParm.IntoMonth);
            liquidateEntity.LiquidateDBEntity[0].DtHisOrder = hisOrderCmd.ExecuteDataSet().Tables[0].Copy();

            DataCommand hisAmountCmd = DataCommandManager.GetDataCommand("GetLiquidateHisAmount");
            hisAmountCmd.SetParameterValue("@SLID", dbParm.SLID);
            hisAmountCmd.SetParameterValue("@UnitID", dbParm.UnitID);
            liquidateEntity.LiquidateDBEntity[0].DtHisAmount = hisAmountCmd.ExecuteDataSet().Tables[0].Copy();
            return liquidateEntity;
        }
コード例 #15
0
        public static LiquidateEntity CommonSelect(LiquidateEntity liquidateEntity)
        {
            OracleParameter[] parm ={
                                    new OracleParameter("PARAMETERS",OracleType.VarChar)
                                };
            LiquidateDBEntity dbParm = (liquidateEntity.LiquidateDBEntity.Count > 0) ? liquidateEntity.LiquidateDBEntity[0] : new LiquidateDBEntity();

            if (String.IsNullOrEmpty(dbParm.AutoQuery))
            {
                parm[0].Value = DBNull.Value;
            }
            else
            {
                parm[0].Value = dbParm.AutoQuery;
            }

            liquidateEntity.QueryResult = DbManager.Query("WebAutoComplete", "t_b_auto_unit", true, parm);
            return liquidateEntity;
        }
コード例 #16
0
 public static LiquidateEntity PrintLiquidateList(LiquidateEntity liquidateEntity)
 {
     return liquidateEntity;
 }
コード例 #17
0
        /// <summary>
        /// 确认清算明细取得
        /// </summary>
        /// <param name="liquidateEntity"></param>
        /// <returns></returns>
        public static LiquidateEntity GetLiquidateDetail(LiquidateEntity liquidateEntity)
        {
            //liquidateEntity.LogMessages.MsgType = MessageType.INFO;
            //liquidateEntity.LogMessages.Content = _nameSpaceClass + "Select";
            //LoggerHelper.LogWriter(liquidateEntity.LogMessages);

            try
            {
                // 结算单位取得
                // 本月订单列表
                // 历史遗漏订单列表
                // 历史遗漏款项列表
                return LiquidateDA.GetLiquidateDetail(liquidateEntity);
            }
            catch (Exception ex)
            {
                //liquidateEntity.LogMessages.MsgType = MessageType.ERROR;
                //liquidateEntity.LogMessages.Content = _nameSpaceClass + "Select  Error: " + ex.Message;
                //LoggerHelper.LogWriter(liquidateEntity.LogMessages);
                throw ex;
            }
        }