110,534
社区成员
发帖
与我相关
我的任务
分享
public string getOneRoomOnePriceListByPage(int houseid, int bid = 0, int uid = 0,int HouseTypeID=0, int pageindex = 1, int pagesize = 10)
{
int erro =1;
JObject jOb = new JObject();
ArrayList List = new ArrayList();
int totalCount = 0;
DataTable dt = AppWXsource.getOneRoomOnePriceListPageByHouseID(houseid);
DataRow[] drArr = null;
if (dt != null&&dt.Rows.Count>0)
{
erro = 1;
if (bid == 0 && uid == 0 && HouseTypeID == 0)
drArr = dt.Select("HouseID=" + houseid);//查询
else if (bid != 0 && uid == 0 && HouseTypeID == 0)
drArr = dt.Select("BuildingID=" + bid);//查询
else if (bid != 0 && uid != 0 && HouseTypeID == 0)
drArr = dt.Select("UnitID=" + uid+ " and BuildingID=" + bid);//查询
else if (bid != 0 && uid != 0 && HouseTypeID != 0)
drArr = dt.Select("HouseTypeID=" + HouseTypeID+ " and UnitID = " + uid + " and BuildingID=" + bid);//查询
if (drArr==null||drArr.Length<=0)
{
jOb.Add(new JProperty("total", totalCount));
jOb.Add(new JProperty("list", List));
return JsonDo.JobjectToJson(jOb,erro, "没有相关的记录");
}
totalCount = drArr.Length;//取得总数
int pagenum = 1;
int lastnum = 0;
pagenum = pagesize * (pageindex - 1);
if ((pagenum + pagesize) > totalCount)
lastnum = totalCount;
else
lastnum = pagenum + pagesize;
for (int i= pagenum; i < lastnum; i++)
{
DataRow rs = drArr[i];
//取得房号,房号户型ID
int RoomID =(int)rs["RoomID"];
string RoomNum = "";
string Rooms = "";
string Halls = "";
string Floors = "";
DataTable Rtd = new DAL.AppWX.room().getRoomAndHouseTypeInfoByRoomID(RoomID);
if(Rtd!=null&&Rtd.Rows.Count>0)
{
RoomNum = Rtd.Rows[0]["RoomNum"].ToString();
Rooms = Rtd.Rows[0]["Rooms"].ToString();
Halls = Rtd.Rows[0]["Halls"].ToString();
Floors = Rtd.Rows[0]["Floors"].ToString();
}
JObject jObj = new JObject();
jObj.Add(new JProperty("SourceID", rs["SourceID"]));
jObj.Add(new JProperty("RoomNum", RoomNum));
var SourceTag = rs["SourceTag"].ToString();
if (SourceTag != "")
{
SourceTag = SourceTag.TrimEnd(',');
SourceTag = new BLL.Source().GetOneHouseAllTagsName(SourceTag.Trim());
}
jObj.Add(new JProperty("SourceTag", SourceTag));
//读取户型资料
string Tid = rs["HouseTypeID"].ToString();
string typeinfo = "";
typeinfo = Rooms + "房" + Halls + "厅";
jObj.Add(new JProperty("housetypes", typeinfo));
jObj.Add(new JProperty("CoveredArea", rs["CoveredArea"]));
jObj.Add(new JProperty("Floors", Floors));
float a = 0;
float b = 0;
float totprice = 0;
float oneprice = 0;
try
{
a = float.Parse(rs["SourcePrice"].ToString());
b = float.Parse(rs["CoveredArea"].ToString());
int pricetype = int.Parse(rs["pricetype"].ToString());
if (pricetype == 2)//2为单价
{
totprice = a * b;
oneprice = a;
}
else
{
totprice = a;
oneprice = a / b;
}
}
catch
{
//
}
//取得房源首图
string SourceImg = "";
int SourceID = int.Parse(rs["sourceID"].ToString());
DataTable dtImg = AppWXsource.getSourceImg(SourceID);
if (dtImg.Rows.Count > 0)
{
SourceImg = ImageUrl + dtImg.Rows[0]["ThumbnailName"].ToString();
}
else
{
//如果房源图片为空,则调取户型图
int houseTypeID = Common.Util.ConvertInt32(rs["HouseTypeID"], 0);
DataTable dtHouseTypeImg = new DAL.House().GetPhotoByHouseType(houseTypeID);
if (dtHouseTypeImg != null && dtHouseTypeImg.Rows.Count > 0)
{
SourceImg = ImageUrl + dtHouseTypeImg.Rows[0]["ThumbnailName"].ToString();
}
}
jObj.Add(new JProperty("SourceImg", SourceImg));
jObj.Add(new JProperty("oneprice", oneprice));
jObj.Add(new JProperty("totprice", totprice));
jObj.Add(new JProperty("IsOnline", rs["IsOnline"]));
jObj.Add(new JProperty("IsSold", rs["IsSold"]));
jObj.Add(new JProperty("HouseTypeID", rs["HouseTypeID"]));
//取得多少栋多少单元多少房号
DataTable dtS = AppWXsource.getHouseNameBuildingNameUnitNameRoomNum(RoomID);
if (dtS.Rows.Count > 0)
{
jObj.Add(new JProperty("HouseName", dtS.Rows[0]["HouseName"]));
jObj.Add(new JProperty("BuildingName", dtS.Rows[0]["BuildingName"]));
jObj.Add(new JProperty("UnitName", dtS.Rows[0]["UnitName"]));
}
List.Add(jObj);
}
}
jOb.Add(new JProperty("total", totalCount));
jOb.Add(new JProperty("list", List));
return JsonDo.JobjectToJson(jOb, erro);
}