/// <summary>
/// 添加布局
/// </summary>
/// <param name="message">消息</param>
/// <returns>状态</returns>
public int AddJiras(CMessage message)
{
List <Jira> layouts = new List <Jira>();
GetLayouts(layouts, message.m_body, message.m_bodyLength);
int layoutsSize = layouts.Count;
List <IndicatorLayout> addLayouts = new List <IndicatorLayout>();
for (int i = 0; i < layoutsSize; i++)
{
IndicatorLayout receive = layouts[i];
receive.m_layoutID = Guid.NewGuid().ToString();
String sql = String.Format("INSERT INTO INDICATORLAYOUT(LAYOUTID, USERID, NAME, TEXT, TYPE, ORDERNUM, CREATETIME, MODIFYTIME) values ('{0}', {1}, '{2}', '{3}', {4}, {5}, '1970-1-1', '1970-1-1')",
CStrA.GetDBString(receive.m_layoutID), receive.m_userID, CStrA.GetDBString(receive.m_name), CStrA.GetDBString(receive.m_text), receive.m_type, receive.m_orderNum);
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
conn.Open();
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
conn.Close();
addLayouts.Add(receive);
}
int ret = Send(message, addLayouts, true);
layouts.Clear();
addLayouts.Clear();
return(ret);
}
/// <summary>
/// 获取模板信息
/// </summary>
/// <param name="template">模板信息</param>
public void GetTemplate(ref SecurityFilterTemplate template)
{
TextBoxA txtName = GetTextBox("txtName");
TextBoxA txtIndicator = GetTextBox("txtIndicator");
TextBoxA txtParameters = GetTextBox("txtParameters");
ComboBoxA cbCycle = GetComboBox("cbCycle");
ComboBoxA cbSubscription = GetComboBox("cbSubscription");
TextBoxA txtFilter = GetTextBox("txtFilter");
if (m_template.m_templateID != null && m_template.m_templateID.Length > 0)
{
template.m_templateID = m_template.m_templateID;
}
template.m_name = txtName.Text;
template.m_indicator = txtIndicator.Text;
template.m_parameters = txtParameters.Text;
if (cbCycle.SelectedValue != null)
{
template.m_cycle = CStrA.ConvertStrToInt(cbCycle.SelectedValue);
}
else
{
template.m_cycle = 1440;
}
template.m_subscription = cbSubscription.SelectedIndex;
template.m_filter = txtFilter.Text;
template.m_codes = m_codes;
template.m_userID = DataCenter.UserID;
}
/// <summary>
/// 更新排序字段
/// </summary>
/// <param name="message">消息</param>
/// <returns>状态</returns>
public int UpdateOrderNum(CMessage message)
{
List <IndicatorLayout> layouts = new List <IndicatorLayout>();
GetLayouts(layouts, message.m_body, message.m_bodyLength);
int layoutsSize = layouts.Count;
List <IndicatorLayout> updateLayouts = new List <IndicatorLayout>();
for (int i = 0; i < layoutsSize; i++)
{
IndicatorLayout receive = layouts[i];
String[] ids = receive.m_layoutID.Split(new String[] { "," }, StringSplitOptions.RemoveEmptyEntries);
int idsSize = ids.Length;
for (int j = 0; j < idsSize; j++)
{
String sql = String.Format("UPDATE INDICATORLAYOUT SET ORDERNUM = {0} WHERE USERID = {1} AND LAYOUTID = '{2}'",
j, receive.m_userID, CStrA.GetDBString(ids[j]));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
updateLayouts.Add(receive);
}
int ret = Send(message, updateLayouts, true);
updateLayouts.Clear();
layouts.Clear();
return(ret);
}
/// <summary>
/// 构造函数
/// </summary>
public TrendData()
{
double shData = SecurityService.m_shTradeTime;
int year = 0, month = 0, day = 0, hour = 0, minute = 0, second = 0, ms = 0;;
CStrA.M130(shData, ref year, ref month, ref day, ref hour, ref minute, ref second, ref ms);
Date = year * 10000 + month * 100 + day;
}
/// <summary>
/// 更新服务器信息
/// </summary>
/// <param name="serverInfo">服务器信息</param>
/// <returns>状态</returns>
public void UpdateServer(ServerInfo serverInfo)
{
String sql = String.Format("UPDATE SERVERS SET IP = '{0}', PORT = {1}, TYPE = '{2}' WHERE ID = '{3}'",
CStrA.GetDBString(serverInfo.m_ip), serverInfo.m_port, CStrA.GetDBString(serverInfo.m_type), CStrA.GetDBString(serverInfo.m_id));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
/// <summary>
/// 更新布局
/// </summary>
/// <param name="layout">布局</param>
public void UpdateLayouts(IndicatorLayout layout)
{
String sql = String.Format("UPDATE INDICATORLAYOUT SET NAME = '{0}', TEXT = '{1}', TYPE = {2}, ORDERNUM = {3} WHERE USERID = {4} AND LAYOUTID = '{5}'",
CStrA.GetDBString(layout.m_name), CStrA.GetDBString(layout.m_text), layout.m_type, layout.m_orderNum, layout.m_userID, CStrA.GetDBString(layout.m_layoutID));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
/// <summary>
/// Windows下获取控件数值
/// </summary>
/// <param name="var">变量</param>
/// <returns>数值</returns>
public double WinGetValue(CVariable var)
{
double value = 0;
INativeBase native = m_chart.Native;
WinformControlHostEx host = native.Host as WinformControlHostEx;
if (host != null)
{
String text = host.GetText();
value = CStrA.ConvertStrToDouble(text);
}
return(value);
}
/// <summary>
/// 更新会话
/// </summary>
/// <param name="cookie">会话</param>
/// <returns>状态</returns>
public int UpdateCookie(UserCookie cookie)
{
String sql = String.Format("UPDATE USERCOOKIE SET VALUE = '{0}' WHERE USERID = {1} AND KEY = '{2}'",
CStrA.GetDBString(cookie.m_value), m_userID, CStrA.GetDBString(cookie.m_key));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return(1);
}
/// <summary>
/// 更新连接信息
/// </summary>
/// <param name="connectInfo">连接信息</param>
/// <returns>状态</returns>
public int UpdateConnect(ConnectInfo connectInfo)
{
String sql = String.Format("UPDATE CONNECTS SET IP = '{0}', PORT = {1}, TYPE = '{2}' WHERE ID = '{3}'",
CStrA.GetDBString(connectInfo.m_ip), connectInfo.m_port, CStrA.GetDBString(connectInfo.m_type), CStrA.GetDBString(connectInfo.m_id));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return(1);
}
/// <summary>
/// 添加服务器
/// </summary>
/// <param name="serverInfo">服务器信息</param>
/// <returns>状态</returns>
public int AddServer(ServerInfo serverInfo)
{
String sql = String.Format("INSERT INTO SERVERS(ID, IP, PORT, TYPE) values ('{0}','{1}', {2}, '{3}')",
CStrA.GetDBString(serverInfo.m_id), CStrA.GetDBString(serverInfo.m_ip), serverInfo.m_port, CStrA.GetDBString(serverInfo.m_type));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
conn.Open();
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
conn.Close();
return(1);
}
/// <summary>
/// 更新代理信息
/// </summary>
/// <param name="proxyInfo">代理信息</param>
/// <returns>状态</returns>
public int UpdateConnect(ProxyInfo proxyInfo)
{
String sql = String.Format("UPDATE PROXYINFOS SET IP = '{0}', PORT = {1}, NAME = '{2}', PASSWORD = '******', DOMAIN='{4}', USE = {5} WHERE TYPE = {6}",
CStrA.GetDBString(proxyInfo.m_ip), proxyInfo.m_port, CStrA.GetDBString(proxyInfo.m_name),
CStrA.GetDBString(proxyInfo.m_pwd), CStrA.GetDBString(proxyInfo.m_domain), proxyInfo.m_use ? 1 : 0, proxyInfo.m_type);
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return(1);
}
/// <summary>
/// 添加代理信息
/// </summary>
/// <param name="proxyInfo">代理信息</param>
/// <returns>状态</returns>
public int AddProxyInfo(ProxyInfo proxyInfo)
{
String sql = String.Format("INSERT INTO PROXYINFOS(TYPE, IP, PORT, NAME, PASSWORD, DOMAIN, USE) values ({0},'{1}',{2},'{3}','{4}','{5}',{6})",
proxyInfo.m_type, CStrA.GetDBString(proxyInfo.m_ip), proxyInfo.m_port, CStrA.GetDBString(proxyInfo.m_name),
CStrA.GetDBString(proxyInfo.m_pwd), CStrA.GetDBString(proxyInfo.m_domain), proxyInfo.m_use ? 1 : 0);
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
conn.Open();
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
conn.Close();
return(1);
}
public override void OnKeyDown(char key)
{
if (key >= 49 && key <= 57)
{
int index = CStrA.ConvertStrToInt(key.ToString()) - 1;
GridIconCell iconCell = GetRow(1).GetCell(index) as GridIconCell;
iconCell.KeyPress = true;
String macroID = iconCell.ID;
Macro macro = new Macro();
if (m_macroService.GetMacroByID(macroID, ref macro))
{
m_macroService.Run(macro);
}
Invalidate();
iconCell.KeyPress = false;
}
}
/// <summary>
/// 添加用户Cookie
/// </summary>
/// <param name="cookie">消息</param>
/// <returns>状态</returns>
public int AddCookie(UserCookie cookie)
{
UserCookie oldCookie = new UserCookie();
if (GetCookie(cookie.m_key, ref oldCookie) > 0)
{
UpdateCookie(cookie);
}
else
{
String sql = String.Format("INSERT INTO USERCOOKIE(USERID, KEY, VALUE, MODIFYTIME, CREATETIME) values ({0}, '{1}', '{2}','1970-1-1','1970-1-1')",
m_userID, CStrA.GetDBString(cookie.m_key), CStrA.GetDBString(cookie.m_value));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
conn.Open();
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
conn.Close();
}
return(1);
}
/// <summary>
/// 获取参数
/// </summary>
private void GetParameters()
{
if (m_indicator != null)
{
m_window.Text = "参数设置(" + m_indicator.Name + ")";
IndicatorData indicatorData = m_indicator.Tag as IndicatorData;
String[] strs = indicatorData.m_parameters.Split(new String[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
int strsSize = strs.Length;
//依此创建控件
int addHeight = 0;
for (int i = 0; i < strsSize; i++)
{
String str = strs[i];
String[] strs2 = str.Split(new String[] { "," }, StringSplitOptions.RemoveEmptyEntries);
String name = strs2[0];
String value = strs2[3];
//创建标签
LabelA label = new LabelA();
POINT location = new POINT(50, addHeight + 40);
label.Location = location;
label.Text = name;
m_window.AddControl(label);
//创建数值控件
SpinA spin = new SpinA();
location.x = 130;
location.y = addHeight + 40;
spin.Location = location;
spin.Maximum = 10000000;
spin.Value = CStrA.ConvertStrToDouble(value);
m_window.AddControl(spin);
addHeight += 30;
}
m_window.Height += addHeight;
//调整按钮的位置
ButtonA cancelButton = GetButton("btnCancel");
ButtonA submitButton = GetButton("btnSubmit");
cancelButton.Top += addHeight;
submitButton.Top += addHeight;
}
}
/// <summary>
/// 获取用户Cookie
/// </summary>
/// <param name="key">键</param>
/// <param name="cookie">会话</param>
/// <returns>状态</returns>
public int GetCookie(String key, ref UserCookie cookie)
{
int state = 0;
String sql = String.Format("SELECT * FROM USERCOOKIE WHERE USERID = {0} AND KEY = '{1}'", m_userID, CStrA.GetDBString(key));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
cookie.m_userID = reader.GetInt32(0);
cookie.m_key = reader.GetString(1);
cookie.m_value = reader.GetString(2);
state = 1;
}
reader.Close();
conn.Close();
return(state);
}
/// <summary>
/// 删除布局
/// </summary>
/// <param name="message">消息</param>
/// <returns>状态</returns>
public int DeleteLayouts(CMessage message)
{
List <IndicatorLayout> layouts = new List <IndicatorLayout>();
GetLayouts(layouts, message.m_body, message.m_bodyLength);
int layoutsSize = layouts.Count;
List <IndicatorLayout> deleteLayouts = new List <IndicatorLayout>();
for (int i = 0; i < layoutsSize; i++)
{
IndicatorLayout receive = layouts[i];
String sql = String.Format("DELETE FROM INDICATORLAYOUT WHERE USERID = {0} AND LAYOUTID = '{1}'", receive.m_userID, CStrA.GetDBString(receive.m_layoutID));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
deleteLayouts.Add(receive);
}
int ret = Send(message, deleteLayouts, true);
layouts.Clear();
deleteLayouts.Clear();
return(ret);
}
/// <summary>
/// 获取布局信息
/// </summary>
/// <param name="layouts">布局信息</param>
/// <param name="userID">用户ID</param>
/// <param name="layoutID">布局ID</param>
public int GetLayouts(List <IndicatorLayout> layouts, int userID, String layoutID)
{
String sql = "";
if (layoutID != null && layoutID.Length > 0)
{
sql = String.Format("SELECT * FROM INDICATORLAYOUT WHERE USERID = {0} AND LAYOUTID = '{1}'", userID, CStrA.GetDBString(layoutID));
}
else
{
if (userID > 0)
{
sql = String.Format("SELECT * FROM INDICATORLAYOUT WHERE USERID = {0} ORDER BY ORDERNUM", userID);
}
else
{
sql = "SELECT * FROM INDICATORLAYOUT ORDER BY ORDERNUM";
}
}
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
IndicatorLayout layout = new IndicatorLayout();
layout.m_layoutID = reader.GetString(0);
layout.m_userID = reader.GetInt32(1);
layout.m_name = reader.GetString(2);
layout.m_text = reader.GetString(3);
layout.m_type = reader.GetInt32(4);
layout.m_orderNum = reader.GetInt32(5);
layouts.Add(layout);
}
reader.Close();
conn.Close();
return(1);
}
/// <summary>
/// 删除用户Cookie
/// </summary>
/// <param name="key">键</param>
/// <returns>状态</returns>
public int DeleteCookie(String key)
{
String sql = String.Format("DELETE FROM USERCOOKIE WHERE USERID = {0} AND KEY = '{1}'", m_userID, CStrA.GetDBString(key));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return(1);
}
/// <summary>
/// 删除服务
/// </summary>
/// <param name="id">编号</param>
/// <returns>状态</returns>
public int DeleteServer(String id)
{
String sql = String.Format("DELETE FROM SERVERS WHERE ID = '{0}'", CStrA.GetDBString(id));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
conn.Open();
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
conn.Close();
return(1);
}
