/// <summary>
        /// 验证交易设置是否合法
        /// </summary>
        /// <param name="TdSet"></param>
        /// <returns></returns>
        public static bool ValidateTradeSet(TradeSet TdSet)
        {
            bool result = true;
            double _expressionfee = 0;

            switch (TdSet.ObjCode)
            {
                case "CCFJSSJ":
                    break;
                case "GDYXQ":
                    break;
                case "YKGS":

                    try
                    {   //([平仓价]-[建仓价])/[点差基值]*[点值]*[数量]-[工费]-[仓储费]
                        string expressionfee = TdSet.ObjValue;

                        string strtmp = expressionfee.Replace("[平仓价]", "1").Replace("[建仓价]", "0").Replace("[数量]", "1").Replace("[点差基值]", "1").Replace("[点值]", "1").Replace("[工费]", "0").Replace("[仓储费]", "0");
                        _expressionfee = Convert.ToDouble(Microsoft.JScript.Eval.JScriptEvaluate(strtmp, Microsoft.JScript.Vsa.VsaEngine.CreateEngine()));

                    }
                    catch (Exception ex)
                    {
                        result = false;
                    }
                    break;
            }
            return result;
        }
        /// <summary>
        /// 修改交易设置
        /// </summary>
        /// <param name="TdSet">交易设置</param>
        /// <param name="LoginId">管理员登陆标识</param>
        /// <returns>修改结果</returns>
        public ResultDesc ModifyTradeSet(TradeSet TdSet, string LoginId)
        {
            ResultDesc rsdc = new ResultDesc();
            string operUser = string.Empty;//操作人
            try
            {
                TradeUser TdUser = new TradeUser();
                #region 判断登陆标识是否过期

                if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser))
                {
                    rsdc.Result = false;
                    rsdc.Desc = ResCode.UL003Desc;
                    return rsdc;
                }
                if (UserType.NormalType == TdUser.UType)
                {
                    rsdc.Result = false;
                    rsdc.Desc = ComFunction.NotRightUser;
                    return rsdc;
                }
                operUser = TdUser.Account;
                #endregion

                #region 验证数据
                if (!ComFunction.ValidateTradeSet(TdSet))
                {
                    rsdc.Result = false;
                    rsdc.Desc = "值不正确";
                    return rsdc;
                }
                #endregion

                List<string> sqlList = new List<string>();
                StringBuilder strbld = new StringBuilder();
                strbld.AppendFormat("update Trade_Set set ");

                strbld.AppendFormat("ObjName='{0}',", TdSet.ObjName);
                strbld.AppendFormat("ObjValue='{0}',", TdSet.ObjValue);
                strbld.AppendFormat("Remark='{0}' ", TdSet.Remark);
                strbld.AppendFormat("where ObjCode='{0}'", TdSet.ObjCode);
                sqlList.Add(strbld.ToString());
                string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac);
                //添加操作记录
                sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')",
                    DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{1}修改交易设置,{0}", TdSet.ObjCode, ipmac)));

                if (!ComFunction.SqlTransaction(sqlList))
                {
                    rsdc.Result = false;
                    rsdc.Desc = "修改交易设置出错";
                    return rsdc;
                }
                rsdc.Result = true;
                rsdc.Desc = "修该交易设置成功";
            }
            catch (Exception ex)
            {
                ComFunction.WriteErr(ex);
                rsdc.Result = false;
                rsdc.Desc = "修改交易设置失败";
            }
            return rsdc;
        }
        /// <summary>
        /// 获取交易设置
        /// </summary>
        /// <param name="sql">查询SQL</param>
        /// <returns>交易设置</returns>
        public static List<TradeSet> GetTradeSetInfo(string sql)
        {
            System.Data.Common.DbDataReader dbreader = null;
            List<TradeSet> TdSetList = new List<TradeSet>();
            try
            {

                dbreader = DbHelper.ExecuteReader(sql);
                while (dbreader.Read())
                {
                    TradeSet TdSet = new TradeSet();
                    TdSet.ObjCode = dbreader["ObjCode"].ToString();
                    TdSet.ObjName = dbreader["ObjName"].ToString();
                    TdSet.ObjValue = dbreader["ObjValue"].ToString();
                    TdSet.Remark = dbreader["Remark"].ToString();
                    TdSetList.Add(TdSet);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message, ex);
            }
            finally
            {
                if (null != dbreader)
                {
                    dbreader.Close();
                    dbreader.Dispose();
                }
            }
            return TdSetList;
        }
        /// <summary>
        /// 添加交易设置
        /// </summary>
        /// <param name="TdSet">交易设置信息</param>
        /// <param name="LoginId">登陆标识</param>
        /// <returns>添加结果</returns>
        public ResultDesc AddTradeSet(TradeSet TdSet, String LoginId)
        {
            ResultDesc rsdc = new ResultDesc();
            string operUser = string.Empty;//操作人
            try
            {
                TradeUser TdUser = new TradeUser();
                #region 判断登陆标识是否过期

                if (!ComFunction.ExistUserLoginID(LoginId, ref TdUser))
                {
                    rsdc.Result = false;
                    rsdc.Desc = ResCode.UL003Desc;
                    return rsdc;
                }
                if (UserType.NormalType == TdUser.UType)
                {
                    rsdc.Result = false;
                    rsdc.Desc = ComFunction.NotRightUser;
                    return rsdc;
                }
                operUser = TdUser.Account;

                #endregion
                List<string> sqlList = new List<string>();
                sqlList.Add(string.Format("insert into Trade_Set([ObjName],[ObjCode],[ObjValue],[Remark]) values('{0}','{1}','{2}','{3}')", TdSet.ObjName, TdSet.ObjCode, TdSet.ObjValue, TdSet.Remark));

                string ipmac = ComFunction.GetIpMac(TdUser.Ip, TdUser.Mac);
                sqlList.Add(string.Format("insert into Base_OperrationLog([OperTime],[Account],[UserType],[Remark]) values('{0}','{1}',{2},'{3}')",
                    DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"), operUser, (int)TdUser.UType, string.Format("{1}添加交易设置:{0}", TdSet.ObjCode, ipmac)));

                if (!ComFunction.SqlTransaction(sqlList))
                {
                    rsdc.Result = false;
                    rsdc.Desc = "添加交易设置出错";
                    return rsdc;
                }
                rsdc.Result = true;
                rsdc.Desc = "添加交易设置成功";
            }
            catch (Exception ex)
            {
                ComFunction.WriteErr(ex);
                rsdc.Result = false;
                rsdc.Desc = "添加交易设置失败";
            }
            return rsdc;
        }