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;
            }
        }
    }
}