/// <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>
/// 添加布局
/// </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="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>
/// 删除布局
/// </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>
/// 获取用户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>
/// 删除用户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>
/// 添加用户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);
}