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("]"); } }