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); }
/// <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; } }
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; }
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; }
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(); } }
public static LiquidateEntity AddLiquidateIssue(LiquidateEntity liquidateEntity) { LiquidateDBEntity dbParm = (liquidateEntity.LiquidateDBEntity.Count > 0) ? liquidateEntity.LiquidateDBEntity[0] : new LiquidateDBEntity(); return liquidateEntity; }
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; }
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; }
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(); }
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; }
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; }
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; }
public static LiquidateEntity FaxLiquidateList(LiquidateEntity liquidateEntity) { return liquidateEntity; }
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; }
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; }
public static LiquidateEntity PrintLiquidateList(LiquidateEntity liquidateEntity) { return liquidateEntity; }
/// <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; } }