public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; int PageSize = Convert.ToInt32(context.Request.Params["pagesize"]); int currentpage = Convert.ToInt32(context.Request.Params["page"]); string sWhere = ""; WhereFilter QF = null; //条件 if (context.Request.Params["where"] != null) { QF = new JavaScriptSerializer().Deserialize <WhereFilter>(context.Request.Params["where"]); //sWhere = QF.GetWhere(); } //排序 if (context.Request.Params["sortorder"] != null) { string sortname = context.Request.Params["sortname"]; string sortorder = context.Request.Params["sortorder"]; sWhere += " order by " + sortname + " " + sortorder; } M_Data_Paging <M_CustomerInfo> lstMCusPage = SQLDBHelper.CreateDBClass <M_CustomerInfo_DB>().Query(QF, (currentpage - 1) * PageSize, currentpage * PageSize); //分页 var griddata = new { Rows = lstMCusPage.lstTObj, Total = lstMCusPage.RowCount }; string str = new JavaScriptSerializer().Serialize(griddata); context.Response.Write(str); } catch (Exception ex) { } }
public static TerminalTypes GetOneTerminalTypes(int id) { TerminalTypes termType = new TerminalTypes(); string sql = "select * from TerminalTypes where ID=" + id.ToString(); DataTable dt = null; try { SQLDBHelper sqlHelper = new SQLDBHelper(); dt = sqlHelper.Query(sql); } catch (Exception e) { throw e; } if (dt != null && dt.Rows.Count > 0) { termType.ID = Convert.ToInt32(dt.Rows[0]["ID"]); termType.Name = dt.Rows[0]["Name"].ToString(); termType.Price = Convert.ToDecimal(dt.Rows[0]["Price"]); if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value) { termType.Remark = dt.Rows[0]["Remark"].ToString(); } else { termType.Remark = string.Empty; } } return(termType); }
private void button1_Click(object sender, EventArgs e) {//解锁 string username = textBox1.Text.Trim(); string pwd = textBox2.Text; SQLDBHelper sqlHelper = new SQLDBHelper(); object o = sqlHelper.GetSingle("select pwd from Managers where username='******'"); if (o != null && o != DBNull.Value) { if (o.ToString() == pwd) { UnlockSystem(); } else { MessageBox.Show("密码错误!"); textBox2.SelectAll(); textBox2.Focus(); } } else { MessageBox.Show("该账号不存在!"); textBox1.SelectAll(); textBox1.Focus(); } }
public int UpdateUser(sys_User request) { using (IDbConnection sqlConn = SQLDBHelper.CreateConnection()) { return(sqlConn.Update(request)); } }
/// <summary> /// 使用存储过程分页返回记录对象集 /// </summary> /// <param name="DataTbleName">输出表名称</param> /// <param name="ReturnFields">返回的字段,多个时,有逗号隔开</param> /// <param name="Where">条件语句,可以为空,表示不使用条件</param> /// <param name="pageIndex">当前页</param> /// <param name="Sort">排序字段,可以为空,使用默认</param> /// <param name="pageSize">每页的行数</param> /// <param name="AllRecords">满足条件的记录数</param> /// <returns></returns> public static IList <EtProjectInfo> GetPageProjectInfos(string DataTbleName, string ReturnFields, string SqlWhere, int pageIndex, string Sort, int pageSize, out Int32 AllRecords) { SqlParameter[] SqlParam = new SqlParameter[] { new SqlParameter("@TableName", SqlDbType.NVarChar, 1000), new SqlParameter("@PrimaryKey", SqlDbType.NVarChar, 200), new SqlParameter("@ReturnFields", SqlDbType.NVarChar, 3000), new SqlParameter("@Where", SqlDbType.NVarChar, 3000), new SqlParameter("@PageIndex", SqlDbType.Int, 4), new SqlParameter("@PageSize", SqlDbType.Int, 4), new SqlParameter("@Sort", SqlDbType.NVarChar, 200) }; SqlParam[0].Value = "ProjectInfo"; SqlParam[1].Value = "EDSID"; SqlParam[2].Value = ReturnFields; SqlParam[3].Value = SqlWhere; SqlParam[4].Value = pageIndex; SqlParam[5].Value = pageSize; SqlParam[6].Value = Sort; DataSet ds = SQLDBHelper.RunProceGetDataSet("usp_GetPageData", SqlParam, DataTbleName); if (ds != null && ds.Tables.Count > 0) { AllRecords = Convert.ToInt32(ds.Tables[1].Rows[0]["RecordCount"]); return(GetProjectInfosByDataTable(ds.Tables[DataTbleName])); } AllRecords = 0; return(null); }
public static List <Managers> GetMoreManagers(string where = "(1=1)") { List <Managers> managers = new List <Managers>(); string sql = "select * from Managers where " + where; DataTable dt = null; try { SQLDBHelper sqlHelper = new SQLDBHelper(); dt = sqlHelper.Query(sql); } catch (Exception e) { throw e; } if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Managers manager = new Managers(); manager.ID = Convert.ToInt32(dt.Rows[i]["ID"]); manager.username = dt.Rows[i]["username"].ToString(); manager.pwd = dt.Rows[i]["pwd"].ToString(); managers.Add(manager); } } return(managers); }
public static void ClearAtennalType() { string proName = "[dbo].[usp_ClearAtennalType]"; List<SqlParameter> listParas = new List<SqlParameter>(); // listParas.Add(SQLDBHelper.CreateSqlParameter("@Id", id)); SQLDBHelper.RunProcGetAffected(proName, listParas.ToArray()); }
public CheckInTool(VideoSourcePlayer videoSource, DataGridView hasCome, DataGridView unCome) { db = new SQLDBHelper(); camera = new CameraTool.CameraTool(videoSource); FCTool = new FaceCompareTools(); this.DGV_HasCome = hasCome; this.DGV_UnCome = unCome; }
/// <summary> /// 获取站点数据 /// </summary> /// <param name="sql"></param> /// <returns></returns> public int GetStationInfo(string sql) { DataSet ds = new DataSet(); ds = SQLDBHelper.Query(sql); if (ds == null || ds.Tables[0].Rows.Count == 0 || ds.Tables[0].Rows == null) { return(0); } return(1); }
public static List <Users> GetMoreUsers(string where = "(1=1)") { List <Users> users = new List <Users>(); string sql = "select * from Users where " + where; DataTable dt = null; try { SQLDBHelper sqlHelper = new SQLDBHelper(); dt = sqlHelper.Query(sql); } catch (Exception e) { throw e; } if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Users user = new Users(); user.ID = Convert.ToInt32(dt.Rows[i]["ID"]); user.Name = dt.Rows[i]["Name"].ToString(); user.Deadline = Convert.ToDateTime(dt.Rows[i]["Deadline"]); user.ContactTel = dt.Rows[i]["ContactTel"].ToString(); if (dt.Rows[i]["ContactAddress"] != null && dt.Rows[i]["ContactAddress"] != DBNull.Value) { user.ContactAddress = dt.Rows[i]["ContactAddress"].ToString(); } else { user.ContactAddress = string.Empty; } if (dt.Rows[i]["Contacter"] != null && dt.Rows[i]["Contacter"] != DBNull.Value) { user.Contacter = dt.Rows[i]["Contacter"].ToString(); } else { user.Contacter = string.Empty; } if (dt.Rows[i]["Remark"] != null && dt.Rows[i]["Remark"] != DBNull.Value) { user.Remark = dt.Rows[i]["Remark"].ToString(); } else { user.Remark = string.Empty; } users.Add(user); } } return(users); }
public static bool UpdateTerminals(Terminals term) { string sql = "update Terminals set TypeID=" + term.TypeID + ", Name='" + term.Name + "', IP='" + term.IP + "', SIM='" + term.SIM + "', RunStatus=" + term.RunStatus + ", UserID=" + term.UserID + ", Remark='" + term.Remark + "', IsEnable=" + term.IsEnable + " where ID=" + term.ID; try { SQLDBHelper sqlHelper = new SQLDBHelper(); int r = sqlHelper.ExecuteSql(sql); return(r > 0); } catch (Exception e) { throw e; } }
public static bool InsertTerminals(Terminals term) { string sql = "insert into Terminals(TypeID, Name, IP, SIM, RunStatus, UserID, Remark, IsEnable) values (" + term.TypeID + ", '" + term.Name + "', '" + term.IP + "', '" + term.SIM + "', " + term.RunStatus + ", " + term.UserID + ", '" + term.Remark + "', " + (term.IsEnable ? "1" : "0") + ")"; try { SQLDBHelper sqlHelper = new SQLDBHelper(); int r = sqlHelper.ExecuteSql(sql); return(r > 0); } catch (Exception e) { throw e; } }
public static bool DeleteTerminalTypes(int id) { string sql = "delete from TerminalTypes where ID=" + id; try { SQLDBHelper sqlHelper = new SQLDBHelper(); int r = sqlHelper.ExecuteSql(sql); return(r > 0); } catch (Exception e) { throw e; } }
public Page <sys_User> GetUsersFor(UserRequest request) { Dictionary <string, SortOrder> orderKey = new Dictionary <string, SortOrder>(); //if (!string.IsNullOrEmpty(request.OrderField)) // orderKey.Add(request.OrderField, request.SortOrder); orderKey.Add("ID", SortOrder.Ascending); List <sys_User> users = new List <sys_User>(); string strSql = @"select * from sys_User where 1=1 "; using (IDbConnection sqlConn = SQLDBHelper.CreateConnection()) { return(sqlConn.QueryPaging <sys_User>(strSql, request, orderKey)); } }
public static bool UpdateUsers(Users user) { string sql = "update Users set Name='" + user.Name + "', Deadline='" + user.Deadline.ToString("yyyy-MM-dd HH:mm:ss") + "', Contacter='" + user.Contacter + "', ContactTel='" + user.ContactTel + "', ContactAddress='" + user.ContactAddress + "', Remark='" + user.Remark + "' where ID=" + user.ID; try { SQLDBHelper sqlHelper = new SQLDBHelper(); int r = sqlHelper.ExecuteSql(sql); return(r > 0); } catch (Exception e) { throw e; } }
public static bool UpdateManagers(Managers manager) { string sql = "update Managers set username='******', pwd='" + manager.pwd + "' where ID=" + manager.ID; try { SQLDBHelper sqlHelper = new SQLDBHelper(); int r = sqlHelper.ExecuteSql(sql); return(r > 0); } catch (Exception e) { throw e; } }
public static bool InsertManagers(Managers manager) { string sql = "insert into Managers(username, pwd) values ('" + manager.username + "', '" + manager.pwd + "')"; try { SQLDBHelper sqlHelper = new SQLDBHelper(); int r = sqlHelper.ExecuteSql(sql); return(r > 0); } catch (Exception e) { throw e; } }
public static bool UpdateTerminalTypes(TerminalTypes termType) { string sql = "update TerminalTypes set Name='" + termType.Name + "', Price=" + termType.Price + ", Remark='" + termType.Remark + "' where ID=" + termType.ID; try { SQLDBHelper sqlHelper = new SQLDBHelper(); int r = sqlHelper.ExecuteSql(sql); return(r > 0); } catch (Exception e) { throw e; } }
public static bool InsertUsers(Users user) { string sql = "insert into Users(Name, Deadline, Contacter, ContactTel, ContactAddress, Remark) values ('" + user.Name + "', '" + user.Deadline + "', '" + user.Contacter + "', '" + user.ContactTel + "', '" + user.ContactAddress + "', '" + user.Remark + "')"; try { SQLDBHelper sqlHelper = new SQLDBHelper(); int r = sqlHelper.ExecuteSql(sql); return(r > 0); } catch (Exception e) { throw e; } }
public static bool InsertTerminalTypes(TerminalTypes termType) { string sql = "insert into TerminalTypes(Name, Price, Remark) values ('" + termType.Name + "', " + termType.Price + ", '" + termType.Remark + "')"; try { SQLDBHelper sqlHelper = new SQLDBHelper(); int r = sqlHelper.ExecuteSql(sql); return(r > 0); } catch (Exception e) { throw e; } }
public static Users GetOneUsers(int id) { Users user = new Users(); string sql = "select * from Users where ID=" + id.ToString(); DataTable dt = null; try { SQLDBHelper sqlHelper = new SQLDBHelper(); dt = sqlHelper.Query(sql); } catch (Exception e) { throw e; } if (dt != null && dt.Rows.Count > 0) { user.ID = Convert.ToInt32(dt.Rows[0]["ID"]); user.Name = dt.Rows[0]["Name"].ToString(); user.Deadline = Convert.ToDateTime(dt.Rows[0]["Deadline"]); user.ContactTel = dt.Rows[0]["ContactTel"].ToString(); if (dt.Rows[0]["Contacter"] != null && dt.Rows[0]["Contacter"] != DBNull.Value) { user.Contacter = dt.Rows[0]["Contacter"].ToString(); } else { user.Contacter = string.Empty; } if (dt.Rows[0]["ContactAddress"] != null && dt.Rows[0]["ContactAddress"] != DBNull.Value) { user.ContactAddress = dt.Rows[0]["ContactAddress"].ToString(); } else { user.ContactAddress = string.Empty; } if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value) { user.Remark = dt.Rows[0]["Remark"].ToString(); } else { user.Remark = string.Empty; } } return(user); }
public static List <Terminals> GetMoreTerminals(string where = "(1=1)") { List <Terminals> terms = new List <Terminals>(); string sql = "select * from Terminals where " + where; DataTable dt = null; try { SQLDBHelper sqlHelper = new SQLDBHelper(); dt = sqlHelper.Query(sql); } catch (Exception e) { throw e; } if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Terminals term = new Terminals(); term.ID = Convert.ToInt32(dt.Rows[i]["ID"]); term.Name = dt.Rows[i]["Name"].ToString(); term.IP = dt.Rows[i]["IP"].ToString(); term.TypeID = Convert.ToInt32(dt.Rows[i]["TypeID"]); term.UserID = Convert.ToInt32(dt.Rows[i]["UserID"]); term.RunStatus = Convert.ToInt32(dt.Rows[i]["RunStatus"]); term.IsEnable = Convert.ToBoolean(dt.Rows[i]["IsEnable"]); if (dt.Rows[i]["SIM"] != null && dt.Rows[i]["SIM"] != DBNull.Value) { term.SIM = dt.Rows[i]["SIM"].ToString(); } else { term.SIM = string.Empty; } if (dt.Rows[i]["Remark"] != null && dt.Rows[i]["Remark"] != DBNull.Value) { term.Remark = dt.Rows[i]["Remark"].ToString(); } else { term.Remark = string.Empty; } terms.Add(term); } } return(terms); }
public void ProcessRequest(HttpContext context) { try { context.Response.ContentType = "text/plain"; int PageSize = Convert.ToInt32(context.Request.Params["pagesize"]); int currentpage = Convert.ToInt32(context.Request.Params["page"]); string sWhere = ""; WhereFilter QF = null; //条件 if (context.Request.Params["where"] != null) { QF = new JavaScriptSerializer().Deserialize <WhereFilter>(context.Request.Params["where"]); //sWhere = QF.GetWhere(); } //排序 if (context.Request.Params["sortorder"] != null) { string sortname = context.Request.Params["sortname"]; string sortorder = context.Request.Params["sortorder"]; sWhere += " order by " + sortname + " " + sortorder; } //M_User m = new M_User //{ // UserID = "a", // UserName = "******", // UserPwd = "s", // UserPermission = "1,2", // UserState = 1, // Remark = "abc", //}; //bool i = SQLDBHelper.CreateDBClass<M_User_DB>().Add(m); M_Data_Paging <M_User> lstMUserPage = SQLDBHelper.CreateDBClass <M_User_DB>().Query(QF, (currentpage - 1) * PageSize, currentpage * PageSize); //分页 var griddata = new { Rows = lstMUserPage.lstTObj, Total = lstMUserPage.RowCount }; string str = new JavaScriptSerializer().Serialize(griddata); context.Response.Write(str); } catch (Exception ex) { } }
public static Terminals GetOneTerminals(int id) { Terminals term = new Terminals(); string sql = "select * from Terminals where ID=" + id.ToString(); DataTable dt = null; try { SQLDBHelper sqlHelper = new SQLDBHelper(); dt = sqlHelper.Query(sql); } catch (Exception e) { throw e; } if (dt != null && dt.Rows.Count > 0) { term.ID = Convert.ToInt32(dt.Rows[0]["ID"]); term.Name = dt.Rows[0]["Name"].ToString(); term.IP = dt.Rows[0]["IP"].ToString(); term.TypeID = Convert.ToInt32(dt.Rows[0]["TypeID"]); term.UserID = Convert.ToInt32(dt.Rows[0]["UserID"]); term.RunStatus = Convert.ToInt32(dt.Rows[0]["RunStatus"]); term.IsEnable = Convert.ToBoolean(dt.Rows[0]["IsEnable"]); if (dt.Rows[0]["SIM"] != null && dt.Rows[0]["SIM"] != DBNull.Value) { term.SIM = dt.Rows[0]["SIM"].ToString(); } else { term.SIM = string.Empty; } if (dt.Rows[0]["Remark"] != null && dt.Rows[0]["Remark"] != DBNull.Value) { term.Remark = dt.Rows[0]["Remark"].ToString(); } else { term.Remark = string.Empty; } } return(term); }
public static string GetTypeNameByID(int typeId) { Users user = new Users(); string sql = "select Name from TerminalTypes where ID=" + typeId; try { SQLDBHelper sqlHelper = new SQLDBHelper(); object o = sqlHelper.GetSingle(sql); if (o != null && o != DBNull.Value) { return(o.ToString()); } } catch (Exception e) { return("[" + e.Message + "]"); } return("未知类型"); }
public static Managers GetOneManagers(int id) { Managers manager = new Managers(); string sql = "select * from Managers where ID=" + id.ToString(); DataTable dt = null; try { SQLDBHelper sqlHelper = new SQLDBHelper(); dt = sqlHelper.Query(sql); } catch (Exception e) { throw e; } if (dt != null && dt.Rows.Count > 0) { manager.ID = Convert.ToInt32(dt.Rows[0]["ID"]); manager.username = dt.Rows[0]["username"].ToString(); manager.pwd = dt.Rows[0]["pwd"].ToString(); } return(manager); }
public static List <TerminalTypes> GetMoreTerminalTypes(string where = "(1=1)") { List <TerminalTypes> termTypes = new List <TerminalTypes>(); string sql = "select * from TerminalTypes where " + where; DataTable dt = null; try { SQLDBHelper sqlHelper = new SQLDBHelper(); dt = sqlHelper.Query(sql); } catch (Exception e) { throw e; } if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { TerminalTypes termType = new TerminalTypes(); termType.ID = Convert.ToInt32(dt.Rows[i]["ID"]); termType.Name = dt.Rows[i]["Name"].ToString(); termType.Price = Convert.ToDecimal(dt.Rows[i]["Price"]); if (dt.Rows[i]["Remark"] != null && dt.Rows[i]["Remark"] != DBNull.Value) { termType.Remark = dt.Rows[i]["Remark"].ToString(); } else { termType.Remark = string.Empty; } termTypes.Add(termType); } } return(termTypes); }
public int AddUser(sys_User request) { using (IDbConnection sqlConn = SQLDBHelper.CreateConnection()) { for (int i = 0; i < 200; i++) { request = new sys_User() { Name = "liwx" + i, Account = "Account" + i, Password = "******" + i.ToString(), Gender = i % 2, Status = 1, IsLimitIP = true, MaxIPCount = 1, Email = "358948567" + i.ToString() + "@qq.com", Mobile = (15821121139 + i).ToString() }; sqlConn.Insert(request); } return(1); } }
/// <summary> /// 取得表的行数 /// </summary> public static int GetRowCountOfAllProjectInfos() { return(SQLDBHelper.GetRowCount("ProjectInfo", "")); }
/// <summary> /// 取得表的行数 /// </summary> public static int GetRowCountOfAllTransTypes() { return(SQLDBHelper.GetRowCount("TransType", "")); }