static Role()
{
Sqlite sqlite = new Sqlite();
SQLiteDataReader sQLiteDataReader = sqlite.Query("select * from role;");
while (sQLiteDataReader.Read())
{
int key = sQLiteDataReader.GetInt32(0);
string value = sQLiteDataReader.GetString(1);
dicRole.Add(key, value);
}
sqlite.Close();
}
public static void Delete(string loglevel, string eventType, DateTime?startDate, DateTime?endDate, string user)
{
StringBuilder stringBuilder = new StringBuilder("delete from log ");
ArrayList arrayList = new ArrayList();
if (!string.IsNullOrEmpty(loglevel))
{
arrayList.Add("loglevel = '" + loglevel + "'");
}
if (!string.IsNullOrEmpty(eventType))
{
arrayList.Add("eventtype = '" + eventType + "'");
}
if (!string.IsNullOrEmpty(user))
{
arrayList.Add("user = '******'");
}
DateTime value;
if (startDate.HasValue && startDate.HasValue)
{
ArrayList arrayList2 = arrayList;
value = startDate.Value;
arrayList2.Add("logtime > datetime('" + value.ToString("yyyy-MM-dd HH:mm:ss") + "')");
}
if (endDate.HasValue && endDate.HasValue)
{
ArrayList arrayList3 = arrayList;
value = endDate.Value;
arrayList3.Add("logtime < datetime('" + value.ToString("yyyy-MM-dd HH:mm:ss") + "')");
}
string text = "";
if (arrayList.Count > 0)
{
string[] value2 = (string[])arrayList.ToArray(typeof(string));
text = string.Join(" and ", value2);
}
if (!string.IsNullOrEmpty(text))
{
stringBuilder.Append(" where " + text);
}
Sqlite sqliteHelper = new Sqlite();
sqliteHelper.Query(stringBuilder.ToString());
sqliteHelper.Close();
}
/// <summary>
/// 记录操作日志到sqlite.
/// </summary>
/// <param name="log">The log.</param>
public static void Log2Sqlite(Log log)
{
if (log != null)
{
try
{
string strSql = string.Format("INSERT INTO log (loglevel,logtime,message,eventtype,user) VALUES ('{0}','{1}','{2}','{3}','{4}');", log.LogLevel, log.LogTime.ToString(ConstDef.longDate), log.Message, log.EventType, log.User);
Sqlite sqlite = new Sqlite();
sqlite.ExecuteNonQuery(strSql);
sqlite.Close();
}
catch (Exception ex)
{
Log2File(null, ex);
}
}
}
/// <summary>
/// Finds the specified where.
/// </summary>
/// <param name="where">The where.</param>
/// <returns>Role.</returns>
public static Role Find(string where)
{
Role role = new Role();
Sqlite sqlite = new Sqlite();
string text = "select * from role ";
if (!string.IsNullOrEmpty(where))
{
text = text + " where " + where;
}
SQLiteDataReader sQLiteDataReader = sqlite.Query(text);
while (sQLiteDataReader.Read())
{
role.Id = sQLiteDataReader.GetInt32(0);
role.Name = sQLiteDataReader.GetString(1);
}
sqlite.Close();
return(role);
}
/// <summary>
/// Queries the specified where.
/// </summary>
/// <param name="where">The where.</param>
/// <returns>List<Role>.</returns>
public static List <Role> Query(string where)
{
List <Role> list = new List <Role>();
string text = "select id,name from role ";
if (!string.IsNullOrEmpty(where))
{
text = text + " where " + where;
}
Sqlite sqlite = new Sqlite();
SQLiteDataReader sQLiteDataReader = sqlite.Query(text);
while (sQLiteDataReader.Read())
{
Role role = new Role();
role.Id = sQLiteDataReader.GetInt32(0);
role.Name = sQLiteDataReader.GetString(1);
list.Add(role);
}
sqlite.Close();
return(list);
}
/// <summary>
/// Finds the specified username.
/// </summary>
/// <param name="username">The username.</param>
/// <returns>User.</returns>
public static User Find(string username)
{
User user = null;
string sql = "SELECT U.ID,U.USERNAME,U.PASSWORD,R.ID,R.NAME FROM user U,role R WHERE R.ID=U.ROLEID AND U.USERNAME ='******'";
Sqlite sqlite = new Sqlite();
SQLiteDataReader sQLiteDataReader = sqlite.Query(sql);
while (sQLiteDataReader.Read())
{
user = new User();
user.Id = sQLiteDataReader.GetInt32(0);
user.UserName = sQLiteDataReader.GetString(1);
user.Password = sQLiteDataReader.GetString(2);
Role role = new Role();
role.Id = sQLiteDataReader.GetInt32(3);
role.Name = sQLiteDataReader.GetString(4);
user.Role = role;
user.RoleId = role.Id;
}
sqlite.Close();
return(user);
}
/// <summary>
/// Finds the specified Authority.
/// </summary>
/// <param name="where">The where.</param>
/// <returns>Authority.</returns>
public static Authority Find(string where)
{
Authority auth = new Authority();
Sqlite sqlite = new Sqlite();
string text = "SELECT A.id,A.name,R.id,R.name FROM auth A,role R WHERE A.roleid=R.id ";
if (!string.IsNullOrEmpty(where))
{
text = text + " AND A." + where;
}
SQLiteDataReader reader = sqlite.Query(text);
while (reader.Read())
{
auth.Id = reader.GetInt32(0);
auth.Name = reader.GetString(1);
Role role = new Role();
role.Id = reader.GetInt32(2);
role.Name = reader.GetString(3);
auth.Role = role;
}
sqlite.Close();
return(auth);
}
