protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request.QueryString["RoomID"])) { int.TryParse(Request.QueryString["RoomID"], out RoomID); } if (!string.IsNullOrEmpty(Request.QueryString["ID"])) { if (int.TryParse(Request.QueryString["ID"], out ID)) { relation = RoomPhoneRelation.GetRoomPhoneRelation(ID); } } if (relation != null) { this.tdRelationProperty.Value = relation.RelationProperty; this.tdRelationType.Value = relation.RelationType; this.tdCompanyName.Value = relation.CompanyName; this.tdRelateName.Value = relation.RelationName; this.tdRelatePhone.Value = relation.RelatePhoneNumber; this.tdIsDefault.Value = relation.IsDefault ? "1" : "0"; this.tdIDCardType.Value = relation.IDCardType == int.MinValue ? "1" : relation.IDCardType.ToString(); this.tdRelateIDCard.Value = relation.RelationIDCard; this.tdRemark.Value = relation.Remark; RoomID = relation.RoomID; } }
private void savefamilyphoto(HttpContext context) { int ID = WebUtil.GetIntValue(context, "ID"); var relation = RoomPhoneRelation.GetRoomPhoneRelation(ID); HttpFileCollection uploadFiles = context.Request.Files; for (int i = 0; i < uploadFiles.Count; i++) { HttpPostedFile postedFile = uploadFiles[i]; string fileOriName = postedFile.FileName; if (fileOriName != "" && fileOriName != null) { string extension = System.IO.Path.GetExtension(fileOriName).ToLower(); string fileName = DateTime.Now.ToFileTime().ToString() + extension; string filepath = "/upload/Family/"; string rootPath = HttpContext.Current.Server.MapPath("~" + filepath); if (!System.IO.Directory.Exists(rootPath)) { System.IO.Directory.CreateDirectory(rootPath); } string Path = rootPath + fileName; postedFile.SaveAs(Path); relation.HeadImg = filepath + fileName; relation.Save(); } } WebUtil.WriteJson(context, new { status = true }); }
private void saveroomphonefamily(HttpContext context) { int ID = GetIntValue(context, "ID"); int RoomID = GetIntValue(context, "RoomID"); RoomPhoneRelation relation = null; if (ID > 0) { relation = RoomPhoneRelation.GetRoomPhoneRelation(ID); } if (relation == null) { relation = new RoomPhoneRelation(); relation.AddTime = DateTime.Now; relation.RoomID = RoomID; } relation.RelationProperty = WebUtil.getServerValue(context, "tdRelationProperty"); relation.RelationType = WebUtil.getServerValue(context, "tdRelationType"); relation.CompanyName = WebUtil.getServerValue(context, "tdCompanyName"); relation.RelationName = WebUtil.getServerValue(context, "tdRelateName"); relation.RelatePhoneNumber = WebUtil.getServerValue(context, "tdRelatePhone"); relation.IsDefault = WebUtil.getServerIntValue(context, "tdIsDefault") == 1; relation.IDCardType = WebUtil.getServerIntValue(context, "tdIDCardType"); relation.RelationIDCard = WebUtil.getServerValue(context, "tdRelateIDCard"); relation.Remark = WebUtil.getServerValue(context, "tdRemark"); string cmdtext = string.Empty; if (relation.IsDefault) { cmdtext += "update [RoomPhoneRelation] set [IsDefault]=0 where RoomID=@RoomID and ID!=@RelationID;"; } using (SqlHelper helper = new SqlHelper()) { try { helper.BeginTransaction(); relation.Save(helper); if (!string.IsNullOrEmpty(cmdtext)) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter("@RoomID", relation.RoomID)); parameters.Add(new SqlParameter("@RoomOwner", relation.RelationName)); parameters.Add(new SqlParameter("@OwnerPhone", relation.RelatePhoneNumber)); parameters.Add(new SqlParameter("@OwnerIDCard", relation.RelationIDCard)); parameters.Add(new SqlParameter("@RelationID", relation.ID > 0 ? relation.ID : 0)); helper.Execute(cmdtext, CommandType.Text, parameters); } helper.Commit(); WebUtil.WriteJson(context, new { status = true, ID = relation.ID }); } catch (Exception ex) { helper.Rollback(); Utility.LogHelper.WriteError("RoomResourceHandler", "命令:saveroomphonefamily", ex); context.Response.Write("{\"status\":false}"); WebUtil.WriteJson(context, new { status = false }); } } }
protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request.QueryString["ID"])) { int ID = 0; if (int.TryParse(Request.QueryString["ID"], out ID)) { relation = RoomPhoneRelation.GetRoomPhoneRelation(ID); } } if (relation != null) { this.tdRelationProperty.Value = relation.RelationProperty; this.tdRelateName.Value = relation.RelationName; this.tdRelatePhone.Value = relation.RelatePhoneNumber; this.tdRelateIDCard.Value = relation.RelationIDCard; this.tdIsDefault.Checked = relation.IsDefault; this.tdIsChargeMan.Checked = relation.IsChargeMan; this.tdIsChargeFee.Checked = relation.IsChargeFee; this.tdIDCardType.Value = relation.IDCardType == int.MinValue ? "1" : relation.IDCardType.ToString(); this.tdBirthday.Value = relation.Birthday == DateTime.MinValue ? "" : relation.Birthday.ToString("yyyy-MM-dd"); this.tdEmailAddress.Value = relation.EmailAddress; this.tdHomeAddress.Value = relation.HomeAddress; this.tdOfficeAddress.Value = relation.OfficeAddress; this.tdBankName.Value = relation.BankName; this.tdBankAccountName.Value = relation.BankAccountName; this.tdBankNo.Value = relation.BankAccountNo; this.tdCustomOne.Value = relation.CustomOne; this.tdCustomTwo.Value = relation.CustomTwo; this.tdCustomThree.Value = relation.CustomThree; this.tdCustomFour.Value = relation.CustomFour; this.tdRemark.Value = relation.Remark; this.tdContractStartTime.Value = relation.ContractStartTime == DateTime.MinValue ? "" : relation.ContractStartTime.ToString("yyyy-MM-dd"); this.tdContractEndTime.Value = relation.ContractEndTime == DateTime.MinValue ? "" : relation.ContractEndTime.ToString("yyyy-MM-dd"); this.tdBrandNote.Value = relation.BrandInfo; this.tdContractNote.Value = relation.ContractNote; this.tdInteresting.Value = relation.Interesting; this.tdConsumeMore.Value = relation.ConsumeMore; this.tdBelongTeam.Value = relation.BelongTeam; this.tdOneCardNumber.Value = relation.OneCardNumber; this.tdChargeForMan.Value = relation.ChargeForMan; this.tdCompanyName.Value = relation.CompanyName; this.canEditName = true; if (relation.ContractID > 0) { var contract_room = Foresight.DataAccess.Contract_Room.GetContract_RoomListByContractID(relation.ContractID).FirstOrDefault(p => p.RoomID == relation.RoomID); this.canEditName = contract_room == null; } this.tdRelationType.Value = relation.RelationType; } }
private void LoadlRelateFamily(HttpContext context) { try { int RoomID = int.Parse(context.Request.Params["RoomID"]); string page = context.Request.Form["page"]; string rows = context.Request.Form["rows"]; string RelationType = context.Request.Params["RelationType"]; long startRowIndex = (long.Parse(page) - 1) * long.Parse(rows); int pageSize = int.Parse(rows); DataGrid dg = RoomPhoneRelation.GetRoomPhoneRelationGridByRoomID(RoomID, RelationType, "order by ID asc", startRowIndex, pageSize); string result = JsonConvert.SerializeObject(dg); context.Response.Write(result); } catch (Exception ex) { Utility.LogHelper.WriteError("RoomResourceHandler", "命令:LoadlRelateFamily", ex); context.Response.Write("{\"rows\":[],\"total\":0,\"page\":0}"); } }
protected void Page_Load(object sender, EventArgs e) { RoomPhoneRelation relationPhone = null; if (!string.IsNullOrEmpty(Request.QueryString["ID"])) { var op = Request.QueryString["op"]; if (!string.IsNullOrEmpty(op) && op.Equals("view")) { this.canEdit = false; } ID = 0; if (int.TryParse(Request.QueryString["ID"], out ID)) { relationPhone = RoomPhoneRelation.GetRoomPhoneRelation(ID); } } if (relationPhone != null) { this.tdRelationProperty.Value = relationPhone.RelationProperty; if (relationPhone.RelationProperty.Equals("geren")) { this.tdRentName.Value = relationPhone.RelationName; } else { this.tdRentName.Value = relationPhone.CompanyName; this.tdCustomerName.Value = relationPhone.RelationName; } this.tdContractPhone.Value = relationPhone.RelatePhoneNumber; this.tdIDCardType.Value = relationPhone.IDCardType == int.MinValue ? "1" : relationPhone.IDCardType.ToString(); this.tdIDCardNo.Value = relationPhone.RelationIDCard; this.tdIDCardAddress.Value = relationPhone.IDCardAddress; this.tdInChargeMan.Value = relationPhone.CompanyInChargeMan; this.tdBusinessLicense.Value = relationPhone.BusinessLicense; this.tdSellerProduct.Value = relationPhone.SellerProduct; } }
protected void Page_Load(object sender, EventArgs e) { this.tdWidth.Value = "210"; this.tdHeight.Value = "99"; string IDs = Request.QueryString["IDs"]; List <int> IDList = new List <int>(); if (string.IsNullOrEmpty(IDs)) { Response.End(); return; } if (!string.IsNullOrEmpty(IDs)) { IDList = JsonConvert.DeserializeObject <List <int> >(IDs); } if (!IsPostBack) { int RoomID = 0; int ContractID = 0; int DefaultChargeManID = 0; var list = ViewRoomFee.GetViewRoomFeeListByIDs(IDList, UserID: WebUtil.GetUser(this.Context).UserID); if (list.Length > 0) { RoomID = list[0].RoomID; ContractID = list[0].ContractID; DefaultChargeManID = list[0].DefaultChargeManID; } foreach (var item in list) { money += item.TotalCost; } this.rptProject.DataSource = list; this.rptProject.DataBind(); var project = Foresight.DataAccess.Project.GetProjectByID(ID: RoomID, ContractID: ContractID); if (project != null) { this.tdRemark.Value = project.CuiFeiNote; this.tdFirstTitle.InnerHtml = project.PrintTitle; if (project.IsDefinePrintSize) { this.tdWidth.Value = project.PrintWidth > 0 ? project.PrintWidth.ToString() : "210"; this.tdHeight.Value = project.PrintHeight > 0 ? project.PrintHeight.ToString() : WebUtil.GetPrintHeight().ToString(); } else { this.tdWidth.Value = "210"; this.tdHeight.Value = WebUtil.GetPrintHeight(project.PrintType).ToString(); } this.IsPrintUnitPrice = project.IsPrintUnitPrice; if (this.IsPrintUnitPrice) { this.ColumnCount++; } this.FullName = project.FullName + "-" + project.Name; } RoomPhoneRelation relation = null; if (DefaultChargeManID > 0) { relation = RoomPhoneRelation.GetRoomPhoneRelation(DefaultChargeManID); } if (relation == null) { relation = RoomPhoneRelation.GetDefaultInChargeFeeRoomPhoneRelation(RoomID, ContractID); } if (relation != null) { this.OwnerName = relation.RelationName; } SetInfo(RoomID); } }
protected void Page_Load(object sender, EventArgs e) { this.tdWidth.Value = "210"; this.tdHeight.Value = "99"; int PrintID = 0; int.TryParse(Request.QueryString["PrintID"], out PrintID); string IDs = Request.QueryString["IDs"]; List <int> IDList = new List <int>(); List <int> RoomIDList = new List <int>(); if (PrintID == 0) { if (string.IsNullOrEmpty(IDs)) { Response.End(); return; } } if (!string.IsNullOrEmpty(IDs)) { IDList = JsonConvert.DeserializeObject <List <int> >(IDs); } if (!IsPostBack) { int RoomID = 0; int ContractID = 0; int DefaultChargeManID = 0; if (PrintID > 0) { var list = ViewRoomFeeHistory.GetViewRoomFeeHistoryListByIDs(0, IDList, PrintID); if (list.Length > 0) { RoomID = list[0].RoomID; ContractID = list[0].ContractID; DefaultChargeManID = list[0].DefaultChargeManID; } this.rptProject.DataSource = list; this.rptProject.DataBind(); printRoomFeeHistory = PrintRoomFeeHistory.GetPrintRoomFeeHistory(PrintID); } else { var list = ViewTempRoomFeeHistory.GetViewTempRoomFeeHistoryListByIDs(IDList); if (list.Length > 0) { RoomID = list[0].RoomID; } foreach (var item in list) { money += item.ChargeFee; TotalCost += item.Cost; } var historyfees = list; this.rptProject.DataSource = historyfees; this.rptProject.DataBind(); } var project = Foresight.DataAccess.Project.GetProjectByID(ID: RoomID, ContractID: ContractID); if (project != null) { this.tdRemark.Value = project.PrintNote; this.tdFirstTitle.Value = project.PrintTitle; if (project.IsDefinePrintSize) { this.tdWidth.Value = project.PrintWidth > 0 ? project.PrintWidth.ToString() : "210"; this.tdHeight.Value = project.PrintHeight > 0 ? project.PrintHeight.ToString() : WebUtil.GetPrintHeight().ToString(); } else { this.tdWidth.Value = "210"; this.tdHeight.Value = WebUtil.GetPrintHeight(project.PrintType).ToString(); } this.FullName = project.FullName + "-" + project.Name; } RoomPhoneRelation relation = null; if (DefaultChargeManID > 0) { relation = RoomPhoneRelation.GetRoomPhoneRelation(DefaultChargeManID); } if (relation == null) { relation = RoomPhoneRelation.GetDefaultInChargeFeeRoomPhoneRelation(RoomID, ContractID); } if (relation != null) { this.OwnerName = relation.RelationName; } if (PrintID <= 0) { GetInfo(RoomID); } SetInfo(); } }
protected void Page_Load(object sender, EventArgs e) { string GUID = Request.QueryString["guid"]; var temp = ChargeBackGuaranteeTemp.GetChargeBackGuaranteeTempListByGUID(GUID); List <decimal> RealPayList = new List <decimal>(); List <string> RemarkList = new List <string>(); this.tdWidth.Value = "210"; this.tdHeight.Value = "99"; List <int> IDList = temp.Select(p => p.HistoryID).ToList(); if (IDList.Count == 0) { Response.End(); return; } if (!IsPostBack) { int RoomID = 0; int DefaultChargeManID = 0; var list = ViewRoomFeeHistory.GetViewRoomFeeHistoryListByIDs(IDList); if (list.Length == 0) { Response.End(); return; } RoomID = list[0].RoomID; DefaultChargeManID = list[0].DefaultChargeManID; var historyfees = list; var newlist = new List <RoomFeeModule>(); foreach (var item in temp) { var roomFeeModule = new RoomFeeModule(); var viewRoomFeeHistory = list.FirstOrDefault(p => p.HistoryID == item.HistoryID); if (viewRoomFeeHistory != null) { roomFeeModule.HistoryID = viewRoomFeeHistory.HistoryID; roomFeeModule.ChargeTime = viewRoomFeeHistory.ChargeTime; roomFeeModule.RealCost = item.RealPay; roomFeeModule.ChargeName = viewRoomFeeHistory.ChargeName; roomFeeModule.PrintNumber = viewRoomFeeHistory.PrintNumber; roomFeeModule.Remark = item.Remark; roomFeeModule.ChargeMan = viewRoomFeeHistory.ChargeMan; this.money += roomFeeModule.RealCost; newlist.Add(roomFeeModule); } } this.rptProject.DataSource = newlist; this.rptProject.DataBind(); var project = Foresight.DataAccess.Project.GetProjectByID(ID: RoomID, ContractID: 0); if (project != null) { this.tdRemark.Value = project.PrintCancelNote; if (project.IsDefinePrintSize) { this.tdWidth.Value = project.PrintWidth > 0 ? project.PrintWidth.ToString() : "210"; this.tdHeight.Value = project.PrintHeight > 0 ? project.PrintHeight.ToString() : WebUtil.GetPrintHeight().ToString(); } else { this.tdWidth.Value = "210"; this.tdHeight.Value = WebUtil.GetPrintHeight(project.PrintType).ToString(); } this.FirstTitle = project.PayPrintTitle; this.SubTitle = project.PayPrintSubTitle; if (string.IsNullOrEmpty(this.FirstTitle)) { this.FirstTitle = WebUtil.GetCompany(this.Context).CompanyName; } this.tdFirstTitle.InnerHtml = this.FirstTitle; if (string.IsNullOrEmpty(this.SubTitle)) { this.SubTitle = "付款单据"; } this.tdSubTitle.InnerText = this.SubTitle; this.FullName = project.FullName + "-" + project.Name; } RoomPhoneRelation relation = null; if (DefaultChargeManID > 0) { relation = RoomPhoneRelation.GetRoomPhoneRelation(DefaultChargeManID); } if (relation == null) { relation = RoomPhoneRelation.GetDefaultInChargeFeeRoomPhoneRelation(RoomID, ContractID: 0); } if (relation != null) { this.OwnerName = relation.RelationName; } GetInfo(RoomID); SetInfo(); } }
private void SetInfo(Foresight.DataAccess.Contract data) { this.tdContractType.Value = data.ContractType > 0 ? data.ContractType.ToString() : "1"; this.tdContractName.Value = data.ContractName; this.tdContractNo.Value = data.ContractNo; this.tdTimeLimit.Value = data.TimeLimit > int.MinValue ? data.TimeLimit.ToString() : ""; this.tdRentStartTime.Value = data.RentStartTime > DateTime.MinValue ? data.RentStartTime.ToString("yyyy-MM-dd") : ""; this.tdRentEndTime.Value = data.RentEndTime > DateTime.MinValue ? data.RentEndTime.ToString("yyyy-MM-dd") : ""; this.tdTimeLimit.Value = data.TimeLimit > int.MinValue ? data.TimeLimit.ToString() : ""; //this.tdContractStatus.Value = data.ContractStatusDesc; //this.tdWarningTime.Value = data.WarningTime > DateTime.MinValue ? data.WarningTime.ToString("yyyy-MM-dd") : ""; this.tdIsContractDivideOn.Checked = data.IsDivideOn; this.tdContractDevicePercent.Value = data.ContractDevicePercent > 0 ? data.ContractDevicePercent.ToString() : ""; this.tdContractBasicRentCost.Value = data.ContractBasicRentCost > 0 ? data.ContractBasicRentCost.ToString() : ""; if (this.canNewRent || canChangeRent) { this.ContractID = 0; int TopContractID = data.ID; string ContractNo = data.ContractNo; if (data.TopContractID > 0) { var topContract = Foresight.DataAccess.Contract.GetContract(data.TopContractID); if (topContract != null) { TopContractID = topContract.ID; ContractNo = topContract.ContractNo; } } if (canNewRent) { this.tdRentStartTime.Value = data.RentEndTime > DateTime.MinValue ? data.RentEndTime.AddDays(1).ToString("yyyy-MM-dd") : ""; this.tdRentEndTime.Value = ""; int total = Foresight.DataAccess.Contract.GetRelatedContractCountByID(TopContractID, 1); this.tdContractNo.Value = ContractNo + "(续" + (total + 1).ToString() + ")"; } else if (canChangeRent) { int total = Foresight.DataAccess.Contract.GetRelatedContractCountByID(TopContractID, 2); this.tdContractNo.Value = ContractNo + "(转" + (total + 1).ToString() + ")"; } } var relationPhone = RoomPhoneRelation.GetRoomPhoneRelation(data.RelationPhoneID); if (canChangeRent) { if (relationPhone != null) { this.oldRelationProperty.InnerHtml = relationPhone.RelationPropertyDesc; this.hdOldRelationProperty.Value = relationPhone.RelationProperty; if (relationPhone.RelationProperty.Equals("geren")) { this.oldRentName.InnerHtml = relationPhone.RelationName; } else { this.oldRentName.InnerHtml = relationPhone.CompanyName; this.oldCustomerName.InnerHtml = relationPhone.RelationName; } this.oldContractPhone.InnerHtml = relationPhone.RelatePhoneNumber; this.oldIDCardType.InnerHtml = relationPhone.IDCardTypeDesc; this.oldIDCardNo.InnerHtml = relationPhone.RelationIDCard; this.oldIDCardAddress.InnerHtml = relationPhone.IDCardAddress; this.oldInChargeMan.InnerHtml = relationPhone.CompanyInChargeMan; this.oldBusinessLicense.InnerHtml = relationPhone.BusinessLicense; this.oldSellerProduct.InnerHtml = relationPhone.SellerProduct; } else { this.oldRelationProperty.InnerHtml = "个人"; this.hdOldRelationProperty.Value = "geren"; this.oldRentName.InnerHtml = data.RentName; this.oldContractPhone.InnerHtml = data.ContractPhone; this.oldCustomerName.InnerHtml = data.RentName; this.oldIDCardType.InnerHtml = ""; this.oldIDCardNo.InnerHtml = data.IDCardNo; this.oldIDCardAddress.InnerHtml = data.IDCardAddress; this.oldInChargeMan.InnerHtml = data.InChargeMan; this.oldBusinessLicense.InnerHtml = data.BusinessLicense; this.oldSellerProduct.InnerHtml = data.SellerProduct; } } else { if (relationPhone != null) { this.tdRelationProperty.Value = relationPhone.RelationProperty; if (relationPhone.RelationProperty.Equals("geren")) { this.tdRentName.Value = relationPhone.RelationName; } else { this.tdRentName.Value = relationPhone.CompanyName; this.tdCustomerName.Value = relationPhone.RelationName; } this.tdContractPhone.Value = relationPhone.RelatePhoneNumber; this.tdIDCardType.Value = relationPhone.IDCardType == int.MinValue ? "1" : relationPhone.IDCardType.ToString(); this.tdIDCardNo.Value = relationPhone.RelationIDCard; this.tdIDCardAddress.Value = relationPhone.IDCardAddress; this.tdInChargeMan.Value = relationPhone.CompanyInChargeMan; this.tdBusinessLicense.Value = relationPhone.BusinessLicense; this.tdSellerProduct.Value = relationPhone.SellerProduct; } else { this.tdRelationProperty.Value = "geren"; this.tdRentName.Value = data.RentName; this.tdContractPhone.Value = data.ContractPhone; this.tdCustomerName.Value = data.RentName; this.tdIDCardType.Value = "1"; this.tdIDCardNo.Value = data.IDCardNo; this.tdIDCardAddress.Value = data.IDCardAddress; this.tdInChargeMan.Value = data.InChargeMan; this.tdBusinessLicense.Value = data.BusinessLicense; this.tdSellerProduct.Value = data.SellerProduct; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["RoomID"] != null) { int.TryParse(Request.QueryString["RoomID"], out RoomID); } if (Request.QueryString["DefaultRelationID"] != null) { int.TryParse(Request.QueryString["DefaultRelationID"], out DefaultRelationID); } if (Request.QueryString["ContractID"] != null) { int.TryParse(Request.QueryString["ContractID"], out ContractID); } if (Request.QueryString["PrintID"] != null) { int.TryParse(Request.QueryString["PrintID"], out PrintID); } if (PrintID > 0) { var history_list = ViewRoomFeeHistory.GetViewRoomFeeHistoryListByPrintID(PrintID); if (history_list.Length > 0) { DefaultRelationID = history_list[0].DefaultChargeManID; RoomID = history_list[0].RoomID; ContractID = history_list[0].ContractID; CanPrintCheque = true; } } Foresight.DataAccess.RoomPhoneRelation data = null; RoomBasic basic = null; using (SqlHelper helper = new SqlHelper()) { if (DefaultRelationID > 0) { data = RoomPhoneRelation.GetRoomPhoneRelation(DefaultRelationID, helper); } if (data == null) { data = RoomPhoneRelation.GetDefaultInChargeFeeRoomPhoneRelation(RoomID, ContractID, helper); } if (data == null) { basic = RoomBasic.GetRoomBasicByRoomID(RoomID, helper); } } if (data != null) { this.RelationID = data.ID; this.tdCompanyName.Value = data.CompanyName; this.tdAddress.Value = data.HomeAddress; this.tdBuyerTaxpayerNumber.Value = data.TaxpayerNumber; this.tdBuyerBankAccountNo.Value = data.BankAccountNo; this.tdBuyerBankName.Value = data.BankName; this.tdBuyerEmailAddress.Value = data.EmailAddress; } if (basic != null) { this.tdCompanyName.Value = basic.ChequeCompanyName; this.tdAddress.Value = basic.ChequeAddress; this.tdBuyerTaxpayerNumber.Value = basic.ChequeTaxpayerNumber; this.tdBuyerBankAccountNo.Value = basic.ChequeBankNo; this.tdBuyerBankName.Value = basic.ChequeBankName; this.tdBuyerEmailAddress.Value = basic.ChequeEmailAddress; } var company = Company.GetCompanies().FirstOrDefault(); if (company != null) { this.tdSellerCompanyName.Value = string.IsNullOrEmpty(company.ChequeTitle) ? company.CompanyName : company.ChequeTitle; this.tdSellerAddress.Value = company.Address; this.tdSellerTaxpayerNumber.Value = company.TaxpayerNumber; this.tdSellerBankNo.Value = company.BankAccountNo; this.tdSellerBankName.Value = company.BankName; this.tdReCheckUserName.Value = company.ReCheckUserName; this.tdCheque_SL.Value = company.Cheque_SL > decimal.MinValue ? company.Cheque_SL.ToString("0.00") : string.Empty; this.tdCheque_FLBM.Value = company.Cheque_FLBM; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { this.tdWidth.Value = "210"; this.tdHeight.Value = "99"; int.TryParse(Request.QueryString["PrintID"], out PrintID); int.TryParse(Request.QueryString["ChargeID"], out ChargeID); this.RoomIDs = Request.QueryString["RoomIDs"]; List <int> RoomIDList = new List <int>(); var newlist = new List <Utility.RoomFeeModule>(); if (!string.IsNullOrEmpty(RoomIDs)) { RoomIDList = JsonConvert.DeserializeObject <List <int> >(RoomIDs); } if (PrintID > 0) { printRoomFeeHistory = PrintRoomFeeHistory.GetPrintRoomFeeHistory(PrintID); var list = ViewRoomFeeHistory.GetPreChargeViewRoomFeeHistoryList(PrintID); for (int i = 0; i < list.Length; i++) { var roomFeeModule = new Utility.RoomFeeModule(); roomFeeModule.ChargeFeeSummaryName = list[i].ChargeFeeSummaryName; roomFeeModule.RealCost = list[i].RealCost; roomFeeModule.ChargeFeeCurrentBalance = list[i].ChargeFeeCurrentBalance; roomFeeModule.TotalRestBalance = list[i].ChargeFeeCurrentBalance - list[i].RealCost; newlist.Add(roomFeeModule); } this.money = printRoomFeeHistory.RealCost; } else { string ChargeFeeSummaryName = "退预收款"; if (ChargeID > 0) { var chargesummary = Foresight.DataAccess.ChargeSummary.GetChargeSummary(ChargeID); ChargeFeeSummaryName = chargesummary != null ? "退" + chargesummary.Name : "退预收款"; } decimal ChargeFeeCurrentBalance = Foresight.DataAccess.ViewRoomBalance.GetPreChargeBalance(RoomIDList, ChargeID); var roomFeeModule = new Utility.RoomFeeModule(); roomFeeModule.ChargeFeeSummaryName = ChargeFeeSummaryName; roomFeeModule.RealCost = ChargeFeeCurrentBalance; roomFeeModule.ChargeFeeCurrentBalance = ChargeFeeCurrentBalance; roomFeeModule.TotalRestBalance = 0; newlist.Add(roomFeeModule); this.money = ChargeFeeCurrentBalance; } this.rptProject.DataSource = newlist; this.rptProject.DataBind(); var project = Foresight.DataAccess.Project.GetProject(RoomIDList[0]); if (project != null) { this.tdRemark.Value = project.PrintNote; if (project.IsDefinePrintSize) { this.tdWidth.Value = project.PrintWidth > 0 ? project.PrintWidth.ToString() : "210"; this.tdHeight.Value = project.PrintHeight > 0 ? project.PrintHeight.ToString() : WebUtil.GetPrintHeight().ToString(); } else { this.tdWidth.Value = "210"; this.tdHeight.Value = WebUtil.GetPrintHeight(project.PrintType).ToString(); } this.FirstTitle = project.PayPrintTitle; this.SubTitle = project.PayPrintSubTitle; if (string.IsNullOrEmpty(this.FirstTitle)) { this.FirstTitle = WebUtil.GetCompany(this.Context).CompanyName; } this.tdFirstTitle.InnerHtml = this.FirstTitle; if (string.IsNullOrEmpty(this.SubTitle)) { this.SubTitle = "付款单据"; } this.tdSubTitle.InnerText = this.SubTitle; this.FullName = project.FullName + "-" + project.Name; } RoomPhoneRelation relation = null; if (relation == null) { relation = RoomPhoneRelation.GetDefaultInChargeFeeRoomPhoneRelation(RoomIDList[0], 0); } if (relation != null) { this.OwnerName = relation.RelationName; } if (printRoomFeeHistory == null) { GetInfo(RoomIDList[0]); } SetInfo(); } }
private void saveapppwd(HttpContext context) { int RelationID = GetIntValue(context, "RelationID"); var relation = RoomPhoneRelation.GetRoomPhoneRelation(RelationID); if (relation == null) { WebUtil.WriteJson(context, new { status = false, errormsg = "房间用户不存在" }); return; } string LoginName = context.Request.Params["LoginName"]; string Pwd = context.Request.Params["Password"]; int IsLocked = WebUtil.GetIntValue(context, "IsLocked"); User user = null; if (relation.UserID > 0) { user = User.GetUser(relation.UserID); } var exist_user = User.GetAPPUserByLoginName(LoginName); if (user == null && exist_user != null) { WebUtil.WriteJson(context, new { status = false, errormsg = "登录名已存在" }); return; } if (user != null && exist_user != null && user.UserID != exist_user.UserID) { WebUtil.WriteJson(context, new { status = false, errormsg = "登录名已存在" }); return; } if (user == null) { user = new User(); user.CreateTime = DateTime.Now; user.Type = UserTypeDefine.APPCustomer.ToString(); user.RealName = relation.RelationName; user.RelationID = RelationID; } user.LoginName = LoginName; if (!string.IsNullOrEmpty(Pwd)) { user.Password = User.EncryptPassword(Pwd); } user.IsLocked = IsLocked == 1 ? true : false; using (SqlHelper helper = new SqlHelper()) { try { helper.BeginTransaction(); user.Save(helper); relation.UserID = user.UserID; relation.Save(helper); helper.Commit(); } catch (Exception ex) { helper.Rollback(); LogHelper.WriteError("UserHandler", "saveapppwd", ex); WebUtil.WriteJson(context, new { status = false }); } } var company = Foresight.DataAccess.Company.GetCompany(WebUtil.GetCompanyID(context)); string errormsg = string.Empty; if (!EncryptHelper.SaveAPPUser(company, user.LoginName, user.Password, user.UserID, user.Type, out errormsg)) { user.Delete(); relation.UserID = 0; relation.Save(); var result = new { status = false, msg = errormsg }; WebUtil.WriteJson(context, result); return; } var usercompany = Foresight.DataAccess.UserCompany.GetUserCompanyByUserID(user.UserID); if (usercompany != null) { usercompany.Delete(); } usercompany = new UserCompany(); usercompany.CompanyID = company.CompanyID; usercompany.UserID = user.UserID; usercompany.Save(); context.Response.Write("{\"status\":true}"); }
private void importroomsource(HttpContext context) { HttpFileCollection uploadFiles = context.Request.Files; if (uploadFiles.Count == 0) { context.Response.Write("请选择一个文件"); return; } if (string.IsNullOrEmpty(uploadFiles[0].FileName)) { context.Response.Write("请选择一个文件"); return; } HttpPostedFile postedFile = uploadFiles[0]; string filepath = HttpContext.Current.Server.MapPath("~/upload/ImportRoomSource/" + DateTime.Now.ToString("yyyyMMdd")); if (!System.IO.Directory.Exists(filepath)) { System.IO.Directory.CreateDirectory(filepath); } string filename = DateTime.Now.ToLocalTime().ToString("yyyyMMddHHmmss") + "_" + postedFile.FileName; string fullpath = Path.Combine(filepath, filename); postedFile.SaveAs(fullpath); string msg = string.Empty; DataTable table = ExcelExportHelper.NPOIReadExcel(fullpath); if (!table.Columns.Contains("资源ID")) { msg += "<p>导入失败,原因:资源ID列不存在</p>"; WebUtil.WriteJson(context, msg); return; } int MinID = table.Select().Min(r => { int ID = 0; if (r.Field <object>("资源ID") != null) { int.TryParse(r.Field <object>("资源ID").ToString(), out ID); } return(ID); }); int MaxID = table.Select().Max(r => { int ID = 0; if (r.Field <object>("资源ID") != null) { int.TryParse(r.Field <object>("资源ID").ToString(), out ID); } return(ID); }); string TableName = Utility.EnumModel.DefineFieldTableName.RoomBasic.ToString(); string TableName_Relation = Utility.EnumModel.DefineFieldTableName.RoomPhoneRelation.ToString(); string isconver = context.Request["isconver"]; bool ImportFailed = false; int count = 0; var comm_helper = new APPCode.CommHelper(); titleList = GetTableColumns(); var basicList = RoomBasic.GetRoomBasicListByMinMaxRoomID(MinID, MaxID); var phoneList = RoomPhoneRelation.GetRoomPhoneRelationListByMinMaxRoomID(MinID, MaxID); using (SqlHelper helper = new SqlHelper()) { try { helper.BeginTransaction(); #region 导入处理 for (int i = 0; i < table.Rows.Count; i++) { count = i; Project project = null; object Value = table.Rows[i]["资源ID"]; int RoomID = 0; if (Value != null) { int.TryParse(Value.ToString(), out RoomID); } if (RoomID > 0) { project = Foresight.DataAccess.Project.GetProject(RoomID, helper); } if (project == null) { msg += "<p>第" + (i + 2) + "行上传失败。原因:所属项目不存在</p>"; ImportFailed = true; break; } if (GetColumnValue("房号", table, i, out Value)) { project.Name = Value.ToString().Trim(); } project.Save(helper); RoomBasic basic = basicList.FirstOrDefault(p => p.RoomID == project.ID); if (isconver.Equals("0") && basic != null) { continue; } if (basic == null) { basic = new RoomBasic(); basic.RoomID = project.ID; basic.AddTime = DateTime.Now; } if (GetColumnValue("期数", table, i, out Value)) { basic.BuildingNumber = Value.ToString().Trim(); } if (GetColumnValue("签约日期", table, i, out Value)) { basic.SignDate = GetDateTimeValue(Value); } if (GetColumnValue("交付时间", table, i, out Value)) { basic.PaymentTime = GetDateTimeValue(Value); } if (GetColumnValue("产权办理时间", table, i, out Value)) { basic.CertificateTime = GetDateTimeValue(Value); } if (GetColumnValue("房产类别", table, i, out Value)) { basic.RoomType = Value.ToString().Trim(); } if (GetColumnValue("精装修情况", table, i, out Value)) { basic.IsJingZhuangXiu = 0; if (Value.ToString().Trim().Equals("是")) { basic.IsJingZhuangXiu = 1; } if (Value.ToString().Trim().Equals("否")) { basic.IsJingZhuangXiu = 2; } } if (GetColumnValue("建筑面积", table, i, out Value)) { basic.BuildingOutArea = GetDecimalValue(Value); } List <RoomPhoneRelation> roomPhoneRelationList = new List <RoomPhoneRelation>(); string phoneName = string.Empty; if (GetColumnValue("业主1", table, i, out Value)) { phoneName = Value.ToString().Trim(); } if (!string.IsNullOrEmpty(phoneName)) { var myPhoneRelation = phoneList.FirstOrDefault(p => p.RoomID == basic.RoomID && p.RelationName.Equals(phoneName)); if (myPhoneRelation == null) { myPhoneRelation = new RoomPhoneRelation(); myPhoneRelation.AddTime = DateTime.Now; myPhoneRelation.RoomID = basic.RoomID; } myPhoneRelation.RelationType = "homefamily"; myPhoneRelation.RelationName = phoneName; if (GetColumnValue("业主1联系方式", table, i, out Value)) { myPhoneRelation.RelatePhoneNumber = Value.ToString().Trim(); } myPhoneRelation.Save(helper); } phoneName = string.Empty; if (GetColumnValue("业主2", table, i, out Value)) { phoneName = Value.ToString().Trim(); } if (!string.IsNullOrEmpty(phoneName)) { var myPhoneRelation = phoneList.FirstOrDefault(p => p.RoomID == basic.RoomID && p.RelationName.Equals(phoneName)); if (myPhoneRelation == null) { myPhoneRelation = new RoomPhoneRelation(); myPhoneRelation.AddTime = DateTime.Now; myPhoneRelation.RoomID = basic.RoomID; } myPhoneRelation.RelationType = "homefamily"; myPhoneRelation.RelationName = phoneName; if (GetColumnValue("业主2联系方式", table, i, out Value)) { myPhoneRelation.RelatePhoneNumber = Value.ToString().Trim(); } myPhoneRelation.Save(helper); } phoneName = string.Empty; if (GetColumnValue("住户1", table, i, out Value)) { phoneName = Value.ToString().Trim(); } if (!string.IsNullOrEmpty(phoneName)) { var myPhoneRelation = phoneList.FirstOrDefault(p => p.RoomID == basic.RoomID && p.RelationName.Equals(phoneName)); if (myPhoneRelation == null) { myPhoneRelation = new RoomPhoneRelation(); myPhoneRelation.AddTime = DateTime.Now; myPhoneRelation.RoomID = basic.RoomID; } myPhoneRelation.RelationType = "rentfamily"; myPhoneRelation.RelationName = phoneName; if (GetColumnValue("住户1联系方式", table, i, out Value)) { myPhoneRelation.RelatePhoneNumber = Value.ToString().Trim(); } myPhoneRelation.Save(helper); } basic.Save(helper); } #endregion if (!ImportFailed) { helper.Commit(); msg += "<p>导入完成</p>"; } else { helper.Rollback(); msg += "<p>导入失败</p>"; } } catch (Exception ex) { LogHelper.WriteError("ImportSourceHandler", "visit: importroomsource", ex); msg = "第" + (count + 2) + "行数据有问题,导入取消"; helper.Rollback(); } context.Response.Write(msg); } }