protected void btnLogin1_Click(object sender, EventArgs e) { DAL.admins dal = new DAL.admins(); Model.admins model = dal.AdminLogin(txtName.Text, txtPassWord.Text); if (model == null) { ShowMessage("用户名或密码错误,请重新登录"); } else { HttpContext.Current.Session["User"] = model; Page.Response.Redirect(@"Index.aspx", true); } }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("SQL2012tblName", SqlDbType.VarChar, 255), * new SqlParameter("SQL2012fldName", SqlDbType.VarChar, 255), * new SqlParameter("SQL2012PageSize", SqlDbType.Int), * new SqlParameter("SQL2012PageIndex", SqlDbType.Int), * new SqlParameter("SQL2012IsReCount", SqlDbType.Bit), * new SqlParameter("SQL2012OrderType", SqlDbType.Bit), * new SqlParameter("SQL2012strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "admins"; * parameters[1].Value = "id"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod /// <summary> /// 管理员登录 /// </summary> public Model.admins AdminLogin(string adminName, string password) { Model.admins admin = null; StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from admins"); strSql.Append(" where uname=@adminName and pwd=@password "); SqlParameter[] parameters = { new SqlParameter("@adminName", SqlDbType.VarChar, 255), new SqlParameter("@password", SqlDbType.VarChar, 255) }; parameters[0].Value = adminName; parameters[1].Value = password; DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DAL.admins dal = new admins(); admin = dal.DataRowToModel(ds.Tables[0].Rows[0]); } return(admin); }