Esempio n. 1
0
        //BaseTablesGetter
        public byte[] BaseDataRequest(byte[] methodBytes)
        {
            byte[]          _metBts    = GZipStreamHelper.GZipDecompress(methodBytes);
            MethodRequest[] _metodReqs = __JsonSerial.Deserialize <MethodRequest[]>(System.Text.Encoding.UTF8.GetString(_metBts));
            if (_metodReqs == null)
            {
                return(null);
            }
            ShareSqlManager _sh = new ShareSqlManager();
            List <List <SimpDataEntery> > _simpEtys = new List <List <SimpDataEntery> >();

            for (int _i = 0, _iCnt = _metodReqs.Length; _i < _iCnt; _i++)
            {
                List <SimpDataEntery> _lis = BaseTablesGetter.GetBaseTablesGetterInstances(_metodReqs[_i].ProceDb).GetBaseTable(
                    MethodRequestHelper.GetParam(_metodReqs[_i], "tableName"),
                    MethodRequestHelper.GetParam(_metodReqs[_i], "ChangTime"),
                    MethodRequestHelper.GetParam(_metodReqs[_i], "schemaMD5"),
                    MethodRequestHelper.GetParam(_metodReqs[_i], "contentsMD5"));

                _simpEtys.Add(_lis);
            }
            string _jsonSimpEtys = __JsonSerial.Serialize(_simpEtys);

            byte[] _bts = System.Text.Encoding.UTF8.GetBytes(_jsonSimpEtys);
            return(GZipStreamHelper.GZipCompress(_bts));
        }
Esempio n. 2
0
        public string DataRequest_By_SimpDEs(string methodRequests)
        {
            JavaScriptSerializer _jsonserial = CreateJsonSerial();

#if SUDID_KEY_REGE
            if (!MachineCode.CurrentMachineCode.Hash.Equals(SUDID_KEY_REGE))
            {
                return(null);
            }
#endif
            //System.ServiceModel.OperationContext.Current
            //if (System.ServiceModel.OperationContext.Current.SessionId.IndexOf("id=1") != -1)
            //{
            //  System.Threading.Thread.Sleep(1000 * 25);
            //}
            MethodRequest[] _metodReqs = _jsonserial.Deserialize <MethodRequest[]>(methodRequests);
            ShareSqlManager _sh        = new ShareSqlManager();
            List <List <SimpDataEntery> > _simpEtys = new List <List <SimpDataEntery> >();
            for (int _i = 0, _iCnt = _metodReqs.Length; _i < _iCnt; _i++)
            {
                List <SimpDataEntery> _lis =
                    (List <SimpDataEntery>)_sh.ExecStoredProc(
                        _metodReqs[_i].ProceName,
                        _metodReqs[_i].ParamKeys,
                        _metodReqs[_i].ParamVals,
                        _metodReqs[_i].ProceDb,
                        RetType.SimpDEs);
                if (string.IsNullOrWhiteSpace(_metodReqs[_i].ProceName))
                {
                    throw (new System.Exception("调用名称为空."));
                }
                if (_metodReqs[_i].ProceName.Equals("Sys_BasicTable_Geter"))
                {
                    if (_lis[2].Rows.Count == 0 && _lis[1].Rows[0][0].Equals(string.Empty))
                    {
                        _simpEtys.Add(null);
                        continue;
                    }

                    _lis.Add(
                        new SimpDataEntery()
                    {
                        Cols = new SimpDataColInf[] {
                            new SimpDataColInf()
                            {
                                name = "MD5",
                                type = (DotNetType)System.Enum.Parse(typeof(DotNetType), "String")
                            }
                        },
                        Rows = new List <object[]>()
                        {
                            new object[] { BaseTablesCheck.GetMd5(
                                               MethodRequestHelper.GetParam(_metodReqs[_i], "tableName"),
                                               MethodRequestHelper.GetParam(_metodReqs[_i], "ChangTime"),
                                               _metodReqs[_i].ProceDb) }
                        }
                    });
                }
                _simpEtys.Add(_lis);
            }
            return(_jsonserial.Serialize(_simpEtys));
        }