271 lines
13 KiB
C#
271 lines
13 KiB
C#
using HZQR.Common;
|
|
using QRWL.Common;
|
|
using QRWL.Web.Common;
|
|
using SuperMap.RealEstate.CoreFrameWork.Dictionary.Business;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using System.Web;
|
|
using Business = SuperMap.RealEstate.HighWay.Storage.Business;
|
|
using Model = SuperMap.RealEstate.HighWay.Storage.Model;
|
|
namespace SuperMap.RealEstate.HighWay.Handler
|
|
{
|
|
/// <summary>
|
|
/// handler_ajax 的摘要说明
|
|
/// </summary>
|
|
public class handler_ajax : IHttpHandler
|
|
{
|
|
|
|
public void ProcessRequest(HttpContext context)
|
|
{
|
|
ServiceModel.Transaction _Transaction = new ServiceModel.Transaction();
|
|
string action_type = HttpContext.Current.Request.Form["action_type"];
|
|
string action_data = HttpContext.Current.Request.Form["action_data"];
|
|
string action_record = "";
|
|
List<ServerPartObject> _ListServerPartObject = null;
|
|
string reString = string.Empty;
|
|
string StrSql = string.Empty;
|
|
List<TreeItem> _ListTreeItem = null;
|
|
switch (action_type)
|
|
{
|
|
#region 获得服务区名称
|
|
case "getServerPartName":
|
|
try
|
|
{
|
|
bool HasFlag = false;
|
|
string ProwerString = "";
|
|
action_data = action_data.Replace("|", ",");
|
|
_ListServerPartObject = new List<ServerPartObject>();
|
|
_ListTreeItem = new List<TreeItem>();
|
|
|
|
|
|
foreach (FieldEnum _FieldEnum in (new FieldEnum(_Transaction)).FillCollection(
|
|
"where FieldEnum_Value in(" + action_data + ")"))
|
|
{
|
|
ProwerString += ProwerString == "" ? _FieldEnum.FieldEnum_ID.ToString() : "," + _FieldEnum.FieldEnum_ID;
|
|
}
|
|
|
|
foreach (Business.SERVERPART _SERVERPART in (new Business.SERVERPART(_Transaction)).FillCollection(
|
|
"where FieldEnum_ID in(" + ProwerString + ") order by SERVERPART_CODE"))
|
|
{
|
|
|
|
TreeItem _TreeItem = new TreeItem();
|
|
|
|
_TreeItem.id = _SERVERPART.SERVERPART_ID_Encrypt;
|
|
_TreeItem.pid = "0";
|
|
_TreeItem.open = false;
|
|
_TreeItem.name = _SERVERPART.SERVERPART_NAME;
|
|
_TreeItem.tag = _SERVERPART.SERVERPART_X.ToString() + "|" + _SERVERPART.SERVERPART_Y.ToString();
|
|
_TreeItem.icon = "/HighWay/Resources/v1_0/TreeView/css/zTreeStyle/img/diy/car.png";
|
|
if (_SERVERPART.SERVERPART_X == null)
|
|
continue;
|
|
if (_SERVERPART.SERVERPART_NAME.Contains("西充"))
|
|
{
|
|
continue;
|
|
}
|
|
if(_SERVERPART.SERVERPART_NAME == Storage.Business.CommonHelper.GetConfigValue("topCompanyName"))
|
|
{
|
|
HasFlag = true;
|
|
}
|
|
_ListTreeItem.Add(_TreeItem);
|
|
}
|
|
|
|
if (!HasFlag)
|
|
{
|
|
//添加蜀越驿网
|
|
Business.SERVERPART _SERVERPART = new Business.SERVERPART(_Transaction);
|
|
_SERVERPART.AddSearchParameter("SERVERPART_CODE","515000");
|
|
if (_SERVERPART.Search())
|
|
{
|
|
TreeItem _TreeItem = new TreeItem();
|
|
_TreeItem.id = _SERVERPART.SERVERPART_ID_Encrypt;
|
|
_TreeItem.pid = "0";
|
|
_TreeItem.open = false;
|
|
_TreeItem.name = _SERVERPART.SERVERPART_NAME;
|
|
_TreeItem.icon = "/HighWay/Resources/v1_0/TreeView/css/zTreeStyle/img/diy/car.png";
|
|
_TreeItem.tag = _SERVERPART.SERVERPART_X.ToString() + "|" + _SERVERPART.SERVERPART_Y.ToString();
|
|
_ListTreeItem.Add(_TreeItem);
|
|
}
|
|
}
|
|
|
|
reString = JsonHelper.ListToJson<TreeItem>(_ListTreeItem, "TreeItem");
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
reString = "error:" + ex.Message;
|
|
}
|
|
break;
|
|
#endregion
|
|
|
|
#region 获得销售数据
|
|
case "getSellDataObject":
|
|
try
|
|
{
|
|
List<SellDataObject> _ListSellDataObject = new List<SellDataObject>();
|
|
StrSql = "SELECT * FROM (SELECT COMMODITY_NAME,SELLCOUNT,SELLPRICE,FACTAMOUNT,SELLDATA_DATE FROM HIGHWAY_SELLDATA.T_SELLDATA WHERE SERVERPART_ID = " +
|
|
action_data.ToDecrypt() + " ORDER BY SELLDATA_DATE DESC) WHERE ROWNUM < 20 ";
|
|
foreach (DataRow _DataRow in (new Business.COMMODITY(_Transaction)).ExecuteDataTable(StrSql).Rows)
|
|
{
|
|
SellDataObject _SellDataObject = new SellDataObject();
|
|
_SellDataObject.name = _DataRow["COMMODITY_NAME"].ToString();
|
|
_SellDataObject.price = _DataRow["SELLPRICE"].ToString();
|
|
_SellDataObject.commoditycount = _DataRow["SELLCOUNT"].ToString();
|
|
_SellDataObject.totalprice = _DataRow["FACTAMOUNT"].ToString();
|
|
_SellDataObject.selltime = DateTime.Parse(_DataRow["SELLDATA_DATE"].ToString()).ToLongTimeString().ToString();
|
|
_ListSellDataObject.Add(_SellDataObject);
|
|
}
|
|
reString = JsonHelper.ListToJson<SellDataObject>(_ListSellDataObject, "SellDataObject");
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
reString = "error:" + ex.Message;
|
|
}
|
|
break;
|
|
#endregion
|
|
|
|
case "getServerPart":
|
|
reString = getServerPart(action_data);
|
|
break;
|
|
//获得对应的子类
|
|
case "getServerPartTypeByCode":
|
|
action_record = HttpContext.Current.Request.Form["action_record"];
|
|
reString = getServerPartTypeByCode(action_data, _Transaction, action_record);
|
|
break;
|
|
|
|
case "getServerPartByType":
|
|
reString = getServerPartByType(action_data, _Transaction);
|
|
break;
|
|
case "getPointPos":
|
|
DataTable _DataTable = new DataTable();
|
|
_DataTable.Columns.Add("MAPINFO");
|
|
_DataTable.Columns.Add("MAP_ADDRESS");
|
|
_DataTable.Columns.Add("MAP_TEL");
|
|
_DataTable.Columns.Add("MAP_OBJECTCODE");
|
|
_DataTable.Columns.Add("MAPX");
|
|
_DataTable.Columns.Add("MAPY");
|
|
try
|
|
{
|
|
//获得服务区数据
|
|
Storage.Business.SERVERPART _SERVERPART = new Storage.Business.SERVERPART(_Transaction);
|
|
_SERVERPART.AddSearchParameter("SERVERPART_ID", action_data.ToDecrypt());
|
|
if (_SERVERPART.Search())
|
|
{
|
|
DataRow _DataRow = _DataTable.NewRow();
|
|
_DataRow["MAPINFO"] = _SERVERPART.SERVERPART_NAME + " " + _SERVERPART.SERVERPART_INFO;
|
|
_DataRow["MAP_ADDRESS"] = _SERVERPART.SERVERPART_ADDRESS;
|
|
_DataRow["MAP_TEL"] = _SERVERPART.SERVERPART_TEL;
|
|
_DataRow["MAP_OBJECTCODE"] = _SERVERPART.SERVERPART_ID_Encrypt;
|
|
if (_SERVERPART.SERVERPART_X == null)
|
|
reString = "error";
|
|
_DataRow["MAPX"] = _SERVERPART.SERVERPART_X;
|
|
_DataRow["MAPY"] = _SERVERPART.SERVERPART_Y;
|
|
_DataTable.Rows.Add(_DataRow);
|
|
}
|
|
string PointString = string.Empty;
|
|
PointString = BaiDuMapHelper.GetBaiduPointString(PointString, _DataTable);
|
|
reString = PointString;//"{\"markerArr\":[" + PointString + "]}";
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
reString = "error:" + ex.Message;
|
|
}
|
|
break;
|
|
|
|
case "getImageDataObject":
|
|
try
|
|
{
|
|
List<ImageObject> _ListImageObject = new List<ImageObject>();
|
|
StrSql = "SELECT * FROM (SELECT IMAGE_PATH,TABLE_ID FROM HIGHWAY_STORAGE.T_IMAGE WHERE TABLE_ID = " + action_data.ToDecrypt() + " AND TABLE_NAME='T_SERVERPART' ORDER BY IMAGE_INDEX ASC) WHERE ROWNUM = 1";
|
|
//图片信息
|
|
foreach (DataRow _DataRow in (new Business.COMMODITY(_Transaction)).ExecuteDataTable(StrSql).Rows)
|
|
{
|
|
ImageObject _ImageObject = new ImageObject();
|
|
_ImageObject.path = _DataRow["IMAGE_PATH"].ToString();
|
|
_ImageObject.code = _DataRow["TABLE_ID"].ToEncrypt();
|
|
_ListImageObject.Add(_ImageObject);
|
|
}
|
|
reString = JsonHelper.ListToJson<ImageObject>(_ListImageObject, "ImageObject");
|
|
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
reString = "error:" + ex.Message;
|
|
}
|
|
break;
|
|
default:
|
|
reString = "error";
|
|
break;
|
|
}
|
|
|
|
context.Response.ContentType = "text/plain";
|
|
context.Response.Write(reString);
|
|
context.Response.End();
|
|
}
|
|
|
|
|
|
private string getServerPart(string param)
|
|
{
|
|
//
|
|
string RetString = "";
|
|
switch (param)
|
|
{
|
|
case "第一区域":
|
|
break;
|
|
case "第二区域": break;
|
|
case "第三区域": break;
|
|
case "第四区域": break;
|
|
case "A类": break;
|
|
case "B类": break;
|
|
case "C类": break;
|
|
}
|
|
return RetString;
|
|
}
|
|
|
|
#region 根据分类方式 或得对应的分类
|
|
private string getServerPartTypeByCode(string param,ServiceModel.Transaction _Transaction,string action_record)
|
|
{
|
|
List<Model.SERVERPARTTYPE> _ListSERVERPARTTYPE = new List<Model.SERVERPARTTYPE>();
|
|
if (action_record != "all")
|
|
{
|
|
foreach (Business.SERVERPARTTYPE _SERVERPARTTYPE in (new Business.SERVERPARTTYPE(_Transaction)).FillCollection("where SERVERPARTSTATICTYPE_ID=" + param.ToDecrypt() + " and rownum <= " + action_record + " order by TYPE_INDEX"))
|
|
{
|
|
_ListSERVERPARTTYPE.Add(_SERVERPARTTYPE.PropertyObject);
|
|
}
|
|
}
|
|
else
|
|
{
|
|
|
|
foreach (Business.SERVERPARTTYPE _SERVERPARTTYPE in (new Business.SERVERPARTTYPE(_Transaction)).FillCollection("where SERVERPARTSTATICTYPE_ID=" + param.ToDecrypt() + " order by TYPE_INDEX"))
|
|
{
|
|
_ListSERVERPARTTYPE.Add(_SERVERPARTTYPE.PropertyObject);
|
|
}
|
|
}
|
|
return JsonHelper.ListToJson<Model.SERVERPARTTYPE>(_ListSERVERPARTTYPE, "SERVERPARTTYPE");
|
|
}
|
|
#endregion
|
|
|
|
#region 方法 -> 根据分类获得对应的服务区
|
|
private string getServerPartByType(string param, ServiceModel.Transaction _Transaction)
|
|
{
|
|
//根据类别获得对应的服务区
|
|
List<Model.SERVERPART> _ListSERVERPART = new List<Model.SERVERPART>();
|
|
foreach (Business.SERVERPART _SERVERPART in (new Business.SERVERPART(_Transaction)).FillCollection("where SERVERPART_ID in (select SERVERPART_ID from HIGHWAY_STORAGE.T_SPSTATICTYPE where SERVERPARTTYPE_ID = " + param.ToDecrypt() + ") order by SERVERPART_CODE"))
|
|
{
|
|
_SERVERPART.PropertyObject.SERVERPART_DESC = "";
|
|
_ListSERVERPART.Add(_SERVERPART.PropertyObject);
|
|
}
|
|
return JsonHelper.ListToJson<Model.SERVERPART>(_ListSERVERPART, "SERVERPART");
|
|
}
|
|
#endregion
|
|
|
|
|
|
public bool IsReusable
|
|
{
|
|
get
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
}
|
|
} |