private ViewContractChargeSummary[] loadcontractchargelist(int ContractID, DateTime StartTime, DateTime EndTime) { ViewContractChargeSummary[] list = new ViewContractChargeSummary[] { }; try { long startRowIndex = 0; int pageSize = int.MaxValue; bool IsLinShi = false; var dg = ViewContractChargeSummary.GetViewContractChargeSummaryGrid(ContractID, string.Empty, StartTime, EndTime, "order by ID desc", startRowIndex, pageSize, IsLinShi, UserID: WebUtil.GetUser(this.Context).UserID); list = dg.rows as ViewContractChargeSummary[]; } catch (Exception ex) { Utility.LogHelper.WriteError("AddContract.aspx", "命令:loadcontractchargelist", ex); } return(list); }
private void SetInfo(Foresight.DataAccess.Contract data) { this.FinalContractID = ContractID; if (this.canNewRent || this.canChangeRent) { this.ContractID = 0; this.TopContractID = data.ID; if (data.TopContractID > 0) { var topContract = Foresight.DataAccess.Contract.GetContract(data.TopContractID); if (topContract != null) { TopContractID = topContract.ID; } } //资源列表 var contractRoomList = Contract_Room.GetContract_RoomListByContractID(TopContractID); //收费标准 var chargeList = Contract_ChargeSummary.GetContract_ChargeSummaryList(TopContractID, string.Empty, 0); using (SqlHelper helper = new SqlHelper()) { try { helper.BeginTransaction(); foreach (var item in contractRoomList) { var dataItem = new Contract_Room { ContractID = 0, GUID = guid, ChargeID = item.ChargeID, RoomID = item.RoomID, RentName = item.RentName, RoomLocation = item.RoomLocation, RoomArea = item.RoomArea }; dataItem.Save(helper); } foreach (var item in chargeList) { var dataItem = new Contract_ChargeSummary { ContractID = 0, GUID = guid, ChargeID = item.ChargeID, RoomType = item.RoomType, }; dataItem.Save(helper); } helper.Commit(); } catch (Exception) { helper.Rollback(); } } if (this.canChangeRent) { //免租期 var freeList = Contract_FreeTime.GetContract_FreeTimeList(TopContractID); //收费标准 var contractChargeList = ViewContractChargeSummary.GetViewContractChargeSummaryByContractID(TopContractID).Where(p => p.CalcualteRestCost > 0); //Contract_RoomCharge.GetContract_RoomChargeListByContractID(TopContractID); using (SqlHelper helper = new SqlHelper()) { try { helper.BeginTransaction(); foreach (var item in contractChargeList) { var dataItem = new Contract_RoomCharge { ContractID = 0, GUID = guid, ChargeID = item.ChargeID, RoomID = item.RoomID, RoomUnitPrice = item.RoomUnitPrice, RoomStartTime = item.RoomStartTime, RoomEndTime = item.RoomEndTime, RoomNewEndTime = item.RoomNewEndTime, RoomCost = item.RoomCost, Remark = item.Remark, AddTime = DateTime.Now, RoomUseCount = item.RoomUseCount, ReadyChargeTime = item.ReadyChargeTime, Contract_TempPriceID = item.Contract_TempPriceID, IsReRent = item.IsReRent, IsContractDivideFee = item.IsContractDivideFee }; dataItem.Save(helper); } helper.Commit(); } catch (Exception) { helper.Rollback(); } } } } }