public void AutoComplete()
{
var __AutoComplete_Common_con__ = new System.Data.SQLite.SQLiteConnection(Models.ConnectionStrings.Common);
__AutoComplete_Common_con__.Open();
#region var users;选取所有记录
var users = new NFinal.DB.NList <__AutoComplete_users__>();
var __AutoComplete_users_command__ = new System.Data.SQLite.SQLiteCommand("select id as uid from users", __AutoComplete_Common_con__);
var __AutoComplete_users_reader__ = __AutoComplete_users_command__.ExecuteReader();
if (__AutoComplete_users_reader__.HasRows)
{
while (__AutoComplete_users_reader__.Read())
{
var __AutoComplete_users_temp__ = new __AutoComplete_users__();
if (!__AutoComplete_users_reader__.IsDBNull(1 - 1))
{
__AutoComplete_users_temp__.uid = __AutoComplete_users_reader__.GetInt64(1 - 1);
}
users.Add(__AutoComplete_users_temp__);
}
}
__AutoComplete_users_reader__.Close();
#endregion
__AutoComplete_Common_con__.Close();
string message = "Hello";
int a = 1;
Models.DAL.Users us = new Models.DAL.Users();
//List<Models.DAL.Users.__GetUsers_users__> uss = us.GetUsers();
//HTML模板文件
Write("<!DOCTYPE html><html xmlns=\"http://www.w3.org/1999/xhtml\"><head runat=\"server\"><meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/><title></title></head><body><form id=\"form1\" runat=\"server\" ><div></div></form>");
if (users.Count > 0)
{
}
else
{
Write("<asp:Label ID=\"Label1\" runat=\"server\" Text=\"Label\"></asp:Label>");
}
var user = users.GetEnumerator(); while (user.MoveNext())
{
Write("<div>");
Write(user.Current.uid);
Write("</div>");
}
Write("</body></html>");
}
public void QueryTop()
{
var __QueryTop_Common_con__ = new System.Data.SQLite.SQLiteConnection(Models.ConnectionStrings.Common);
__QueryTop_Common_con__.Open();
#region var users; 随机选取前N行
var users = new NFinal.DB.NList <__QueryTop_users__>();
var __QueryTop_users_command__ = new System.Data.SQLite.SQLiteCommand(string.Format("select * from users Limit {0}", 2), __QueryTop_Common_con__);
var __QueryTop_users_reader__ = __QueryTop_users_command__.ExecuteReader();
if (__QueryTop_users_reader__.HasRows)
{
while (__QueryTop_users_reader__.Read())
{
var __QueryTop_users_temp__ = new __QueryTop_users__();
if (!__QueryTop_users_reader__.IsDBNull(1 - 1))
{
__QueryTop_users_temp__.id = __QueryTop_users_reader__.GetInt64(1 - 1);
}
if (!__QueryTop_users_reader__.IsDBNull(2 - 1))
{
__QueryTop_users_temp__.name = __QueryTop_users_reader__.GetString(2 - 1);
}
if (!__QueryTop_users_reader__.IsDBNull(3 - 1))
{
__QueryTop_users_temp__.pwd = __QueryTop_users_reader__.GetString(3 - 1);
}
users.Add(__QueryTop_users_temp__);
}
}
__QueryTop_users_reader__.Close();
#endregion
__QueryTop_Common_con__.Close();
//foreach (var user in users)
//{
// Write(user.id);
// Write(user.name);
// Write(user.pwd);
//}
}
public void QueryAll()
{
var __QueryAll_Common_con__ = new System.Data.SQLite.SQLiteConnection(Models.ConnectionStrings.Common);
__QueryAll_Common_con__.Open();
#region var users;选取所有记录
var users = new NFinal.DB.NList <__QueryAll_users__>();
var __QueryAll_users_command__ = new System.Data.SQLite.SQLiteCommand("select u.id as uid,count(*) from users as u where u.id<0", __QueryAll_Common_con__);
var __QueryAll_users_reader__ = __QueryAll_users_command__.ExecuteReader();
if (__QueryAll_users_reader__.HasRows)
{
while (__QueryAll_users_reader__.Read())
{
var __QueryAll_users_temp__ = new __QueryAll_users__();
if (!__QueryAll_users_reader__.IsDBNull(1 - 1))
{
__QueryAll_users_temp__.uid = __QueryAll_users_reader__.GetInt64(1 - 1);
}
if (!__QueryAll_users_reader__.IsDBNull(2 - 1))
{
__QueryAll_users_temp__._column1 = __QueryAll_users_reader__.GetInt64(2 - 1);
}
users.Add(__QueryAll_users_temp__);
}
}
__QueryAll_users_reader__.Close();
#endregion
__QueryAll_Common_con__.Close();
//foreach (var user in users)
//{
// Write(user.id);
// Write(user.name);
// Write(user.pwd);
//}
}
public NFinal.DB.NList <__GetUsers_users__> GetUsers()
{
var __GetUsers_Common_con__ = new System.Data.SQLite.SQLiteConnection(Models.ConnectionStrings.Common);
__GetUsers_Common_con__.Open();
#region var users;选取所有记录
var users = new NFinal.DB.NList <__GetUsers_users__>();
var __GetUsers_users_command__ = new System.Data.SQLite.SQLiteCommand("select * from users", __GetUsers_Common_con__);
var __GetUsers_users_reader__ = __GetUsers_users_command__.ExecuteReader();
if (__GetUsers_users_reader__.HasRows)
{
while (__GetUsers_users_reader__.Read())
{
var __GetUsers_users_temp__ = new __GetUsers_users__();
if (!__GetUsers_users_reader__.IsDBNull(1 - 1))
{
__GetUsers_users_temp__.id = __GetUsers_users_reader__.GetInt64(1 - 1);
}
if (!__GetUsers_users_reader__.IsDBNull(2 - 1))
{
__GetUsers_users_temp__.name = __GetUsers_users_reader__.GetString(2 - 1);
}
if (!__GetUsers_users_reader__.IsDBNull(3 - 1))
{
__GetUsers_users_temp__.pwd = __GetUsers_users_reader__.GetString(3 - 1);
}
users.Add(__GetUsers_users_temp__);
}
}
__GetUsers_users_reader__.Close();
#endregion
__GetUsers_Common_con__.Close();
return(users);
}
public virtual void WriteJson(NFinal.DB.NList <NFinal.DB.Struct> str, System.IO.TextWriter tw)
{
if (str == null)
{
tw.Write("null");
}
else
{
tw.Write("[");
if (str.Count > 0)
{
for (int i = 0; i < str.Count; i++)
{
if (i != 0)
{
tw.Write(",");
}
str[i].WriteJson(tw);
}
}
tw.Write("]");
}
}
