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