private void SetInfo(RoomBasic data) { this.tbRoomState.Value = data.RoomStateID > 0 ? data.RoomStateID.ToString() : ""; this.tdBuildingArea.Value = data.BuildingArea == decimal.MinValue ? "" : data.BuildingArea.ToString(); this.tdContractArea.Value = data.ContractArea == decimal.MinValue ? "" : data.ContractArea.ToString(); this.tbPaymentTime.Value = data.PaymentTime == DateTime.MinValue ? "" : data.PaymentTime.ToString("yyyy-MM-dd"); this.tdMoveInTime.Value = data.MoveInTime == DateTime.MinValue ? "" : data.MoveInTime.ToString("yyyy-MM-dd"); this.tdZxStartTime.Value = data.ZxStartTime == DateTime.MinValue ? "" : data.ZxStartTime.ToString("yyyy-MM-dd"); this.tdZxEndTime.Value = data.ZxEndTime == DateTime.MinValue ? "" : data.ZxEndTime.ToString("yyyy-MM-dd"); this.tdRoomLayout.Value = data.RoomLayout; this.tbBuildingNumber.Value = data.BuildingNumber; this.tdBuildOutArea.Value = data.BuildOutArea == decimal.MinValue ? "" : data.BuildOutArea.ToString(); this.tdBuildInArea.Value = data.BuildInArea == decimal.MinValue ? "" : data.BuildInArea.ToString(); this.tdGonTanArea.Value = data.GonTanArea == decimal.MinValue ? "" : data.GonTanArea.ToString(); this.tdChanQuanArea.Value = data.ChanQuanArea == decimal.MinValue ? "" : data.ChanQuanArea.ToString(); this.tdUseArea.Value = data.UseArea == decimal.MinValue ? "" : data.UseArea.ToString(); this.tdPeiTaoArea.Value = data.PeiTaoArea == decimal.MinValue ? "" : data.PeiTaoArea.ToString(); this.tdFunctionCoefficient.Value = data.FunctionCoefficient == decimal.MinValue ? "" : data.FunctionCoefficient.ToString(); this.tdFenTanCoefficient.Value = data.FenTanCoefficient == decimal.MinValue ? "" : data.FenTanCoefficient.ToString(); this.tdChanQuanNo.Value = data.ChanQuanNo; this.tdCertificateTime.Value = data.CertificateTime == DateTime.MinValue ? "" : data.CertificateTime.ToString("yyyy-MM-dd"); this.tbRoomProperty.Value = data.RoomPropertyID > 0 ? data.RoomPropertyID.ToString() : ""; this.tbRoomType.Value = data.RoomTypeID > 0 ? data.RoomTypeID.ToString() : ""; this.tdCustomOne.Value = data.CustomOne; this.tdCustomTwo.Value = data.CustomTwo; this.tdCustomThree.Value = data.CustomThree; this.tdCustomFour.Value = data.CustomFour; this.hdRemark.Value = data.Remark; this.tdIsLocked.Value = data.IsLocked ? "1" : "0"; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (string.IsNullOrEmpty(Request.QueryString["RoomID"])) { Response.End(); return; } int RoomID = int.Parse(Request.QueryString["RoomID"]); RoomBasic basic = RoomBasic.GetRoomBasicByRoomID(RoomID); if (basic != null) { SetInfo(basic); } var project = Project.GetProject(RoomID); if (project != null) { this.tbRoomName.Value = project.Name; string[] SortOrderArray = project.DefaultOrder.Split('-'); int SortOrder = 0; if (SortOrderArray.Length > 0) { int.TryParse(SortOrderArray[SortOrderArray.Length - 1], out SortOrder); } this.tdSortOrder.Value = SortOrder.ToString(); } } }
private void SetInfo(RoomBasic data) { if (data.RoomID > 0) { } this.tbBuildingNumber.Value = data.BuildingNumber; this.tdSignDate.Value = WebUtil.GetStrDate(data.SignDate); this.tbPaymentTime.Value = WebUtil.GetStrDate(data.PaymentTime); this.tdCertificateTime.Value = WebUtil.GetStrDate(data.CertificateTime); this.tbRoomType.Value = data.RoomType; this.tdIsJingZhuangXiu.Value = data.IsJingZhuangXiu > 0 ? data.IsJingZhuangXiu.ToString() : ""; this.tdBuildingOutArea.Value = data.BuildingOutArea > 0 ? data.BuildingOutArea.ToString() : ""; }
private void saveroomresource(HttpContext context) { int RoomID = WebUtil.GetIntValue(context, "RoomID"); Project project = Project.GetProject(RoomID); if (project == null) { WebUtil.WriteJson(context, new { status = false, error = "房间不存在" }); return; } RoomBasic basic = RoomBasic.GetRoomBasicByRoomID(RoomID); string list = context.Request["FieldList"]; List <Utility.BasicModel> ModelList = JsonConvert.DeserializeObject <List <Utility.BasicModel> >(list); using (SqlHelper helper = new SqlHelper()) { try { helper.BeginTransaction(); project.Name = WebUtil.getServerValue(context, "tbRoomName"); int SortOrder = WebUtil.getServerIntValue(context, "tdSortOrder"); if (!string.IsNullOrEmpty(project.DefaultOrder)) { string NewDefaultOrder = string.Empty; string[] SortOrderArray = project.DefaultOrder.Split('-'); for (int i = 0; i < SortOrderArray.Length; i++) { if (i != SortOrderArray.Length - 1) { NewDefaultOrder += SortOrderArray[i] + "-"; } else { NewDefaultOrder += SortOrder.ToString("D3"); } } project.DefaultOrder = NewDefaultOrder; } project.Save(helper); if (basic == null) { basic = new RoomBasic(); basic.RoomID = project.ID; basic.AddTime = DateTime.Now; } basic.BuildingNumber = WebUtil.getServerValue(context, "tbBuildingNumber"); basic.SignDate = WebUtil.getServerTimeValue(context, "tdSignDate"); basic.PaymentTime = WebUtil.getServerTimeValue(context, "tbPaymentTime"); basic.CertificateTime = WebUtil.getServerTimeValue(context, "tdCertificateTime"); basic.RoomType = WebUtil.getServerValue(context, "tbRoomType"); basic.IsJingZhuangXiu = WebUtil.getServerIntValue(context, "tdIsJingZhuangXiu"); basic.BuildingOutArea = WebUtil.getServerDecimalValue(context, "tdBuildingOutArea"); basic.Save(helper); if (ModelList.Count > 0) { foreach (var item in ModelList) { if (item.id <= 0) { continue; } var roombasic_field = RoomBasicField.GetRoomBasicFieldByRoomIDandFieldID(RoomID, item.id, helper); if (roombasic_field == null) { roombasic_field = new RoomBasicField(); roombasic_field.AddTime = DateTime.Now; } roombasic_field.RoomID = RoomID; roombasic_field.FieldID = item.id; roombasic_field.FieldContent = item.value; roombasic_field.Save(helper); } } helper.Commit(); WebUtil.WriteJson(context, new { status = true }); } catch (Exception ex) { helper.Rollback(); Utility.LogHelper.WriteError("RoomResourceHandler", "命令:saveroomresource", ex); WebUtil.WriteJson(context, new { status = false }); } } }
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; } } }
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); } }