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