/// <summary> /// 查询用户租赁信息 /// </summary> /// <param name="Row"></param> /// <returns></returns> public string RentalHistoryList(DataRow Row) { string backstr = ""; DataTable dt = null; try { string ConnStr = ConnectionDb.GetUnifiedConnectionString(); string UserId = Row["UserId"].ToString(); IDbConnection com = new SqlConnection(ConnStr); //Tb_User User = com.Query<Tb_User>("select * from Tb_User where Id=@Id", new { Id = UserId }).ToList<Tb_User>().SingleOrDefault(); //if (User==null) //{ // return JSONHelper.FromString(false, "该用户不存在"); //} int page = AppGlobal.StrToInt(Row["Page"].ToString()); int row = AppGlobal.StrToInt(Row["PageSize"].ToString()); dt = BaseGetData.GetList(ConnStr, " and UserId='" + UserId + "'", page, row, "RegisterDate", 0, "View_Tb_Rental", "Id").Tables[0]; } catch (Exception ex) { backstr = ex.Message; } if (backstr == "") { return(JSONHelper.FromString(dt)); } else { return(JSONHelper.FromString(false, backstr)); } }
private string GetRentalTop(DataRow Row) { string backstr = ""; DataTable dt = null; try { string ConnStr = ConnectionDb.GetUnifiedConnectionString(); StringBuilder sb = new StringBuilder(); if (Row.Table.Columns.Contains("AppleBundleID") && Row["AppleBundleID"].ToString() != "")//苹果包名 { sb.AppendFormat(" AND CommunityId in(select Id from Tb_Community where AppleBundleID = '{0}') ", Row["AppleBundleID"]); } if (Row.Table.Columns.Contains("AndroidPackageName") && Row["AndroidPackageName"].ToString() != "")//安桌包名 { sb.AppendFormat(" AND CommunityId in(select Id from Tb_Community where AndroidPackageName = '{0}') ", Row["AndroidPackageName"]); } sb.AppendFormat(" AND ProcessState='发布' AND BussType='{0}'", Row["BussType"].ToString()); if (Row["BussType"].ToString() == "租售") { sb.AppendFormat(@" AND (convert(NVARCHAR(20),Rent) <> '面议' OR (convert(DECIMAL(18,2), replace(rent, '面议', '0'))>=0 AND convert(DECIMAL(18,2), replace(rent, '面议', '0'))<=99999999) OR Rent IS NULL)"); } if (Row["BussType"].ToString() == "转让") { sb.AppendFormat(" AND ((Amount>=0 AND Amount<=99999999) OR Amount IS NULL)"); } int page = 1; int row = 5; dt = BaseGetData.GetList(ConnStr, sb.ToString(), page, row, "RegisterDate", 1, "View_Tb_Rental", "Id").Tables[0]; } catch (Exception ex) { backstr = ex.Message; } if (backstr == "") { return(JSONHelper.FromString(dt)); } else { return(JSONHelper.FromString(false, backstr)); } }
//房屋租赁列表 public string RentalList(DataRow Row) { string backstr = ""; DataTable dt = null; try { string ConnStr = ConnectionDb.GetUnifiedConnectionString(); StringBuilder sb = new StringBuilder(); if (Row.Table.Columns.Contains("CommunityId") && Row["CommunityId"].ToString() != "") { sb.AppendFormat(" AND CommunityId='{0}'", Row["CommunityId"].ToString()); } else { if (string.IsNullOrEmpty(Row["City"].ToString()) == false) { sb.AppendFormat(" AND (City LIKE '%{0}%' OR Province LIKE '%{0}%')", Row["City"].ToString().Replace("市", "")); } if (Row.Table.Columns.Contains("AppleBundleID") && Row["AppleBundleID"].ToString() != "")//苹果包名 { sb.AppendFormat(" AND CommunityId in(select Id from Tb_Community where AppleBundleID = '{0}') ", Row["AppleBundleID"]); } if (Row.Table.Columns.Contains("AndroidPackageName") && Row["AndroidPackageName"].ToString() != "")//安桌包名 { sb.AppendFormat(" AND CommunityId in(select Id from Tb_Community where AndroidPackageName = '{0}') ", Row["AndroidPackageName"]); } } sb.AppendFormat(" AND ProcessState='发布' AND BussType='{0}'", Row["BussType"].ToString()); if (string.IsNullOrEmpty(Row["HouseType"].ToString()) == false) { sb.AppendFormat(" AND HouseType LIKE '%{0}%'", Row["HouseType"].ToString()); } if (Row["BussType"].ToString() == "租售") { sb.AppendFormat(@" AND (convert(NVARCHAR(20),Rent) <> '面议' AND (convert(DECIMAL(18,2), replace(rent, '面议', '0'))>={0} AND convert(DECIMAL(18,2), replace(rent, '面议', '0'))<={1}) OR Rent IS NULL)", Row["StartAmount"].ToString(), Row["EndAmount"].ToString()); } if (Row["BussType"].ToString() == "转让") { sb.AppendFormat(" AND ((Amount>={0} AND Amount<={1}) OR Amount IS NULL)", Row["StartAmount"].ToString(), Row["EndAmount"].ToString()); } int page = AppGlobal.StrToInt(Row["Page"].ToString()); int row = AppGlobal.StrToInt(Row["PageSize"].ToString()); dt = BaseGetData.GetList(ConnStr, sb.ToString(), page, row, "RegisterDate", 1, "View_Tb_Rental", "Id").Tables[0]; } catch (Exception ex) { backstr = ex.Message; } if (backstr == "") { return(JSONHelper.FromString(dt)); } else { return(JSONHelper.FromString(false, backstr)); } }