RequiredFieldValidatorrunat="server"ControlToValidate="Password"CssClass="text-danger"ErrorMessage="“密码”字段是必填字段。
"/>
Labelrunat="server"AssociatedControlID="DropDownList1"CssClass="col-md-2control-label">类型
Label>
DropDownListID="DropDownList1"runat="server"CssClass="form-control">
ListItemValue="1">管理员
ListItem>
ListItemValue="2">学生
ListItem>
DropDownList>
Buttonrunat="server"id="submit"Text="登录"CssClass="btnbtn-default"OnClick="submit_Click"/>
Content>
(2)编写代码
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingBLL;
usingModel;
namespaceWeb
{
publicpartialclassLogin:
System.Web.UI.Page
{
protectedvoidPage_Load(objectsender,EventArgse)
{
}
protectedvoidsubmit_Click(objectsender,EventArgse)
{
stringusertype=DropDownList1.SelectedValue;
stringname=UserName.Text.Trim();
stringpwd=Password.Text.Trim();
if(usertype=="1")//管理员
{
AdminBLLbll=newAdminBLL();
Adminmodel=bll.GetModel(name,pwd);
if(model!
=null)
{
Response.Redirect("welcome.aspx");
}
else
{
FailureText.Text="Invalidusernameorpassword.";
ErrorMessage.Visible=true;
}
}
elseif(usertype=="2")//学生
{
/*
studentBLLbll=newstudentBLL();
studentmodel=bll.GetModel(name,pwd);
if(model!
=null)
{
Response.Redirect("welcome.aspx");
}
else
{FailureText.Text="Invalidusernameorpassword.";
ErrorMessage.Visible=true;
}
*/
}
}
}
}
第二节数据列表显示
1.dal层
///
///获得数据列表
///
publicDataSetGetList(stringstrWhere)
{
StringBuilderstrSql=newStringBuilder();
strSql.Append("selectadminID,LoginID,LoginPWD,AdminName,sex");
strSql.Append("FROMAdmin");
if(strWhere.Trim()!
="")
{
strSql.Append("where"+strWhere);
}
returnDbHelperSQL.Query(strSql.ToString());
}
///
///获得前几行数据
///
publicDataSetGetList(intTop,stringstrWhere,stringfiledOrder)
{
StringBuilderstrSql=newStringBuilder();
strSql.Append("select");
if(Top>0)
{
strSql.Append("top"+Top.ToString());
}
strSql.Append("adminID,LoginID,LoginPWD,AdminName,sex");
strSql.Append("FROMAdmin");
if(strWhere.Trim()!
="")
{
strSql.Append("where"+strWhere);
}
strSql.Append("orderby"+filedOrder);
returnDbHelperSQL.Query(strSql.ToString());
}
///
///批量删除数据
///
publicboolDeleteList(stringadminIDlist)
{
StringBuilderstrSql=newStringBuilder();
strSql.Append("deletefromAdmin");
strSql.Append("whereadminIDin("+adminIDlist+")");
introws=DbHelperSQL.ExecuteSql(strSql.ToString());
if(rows>0)
{
returntrue;
}
else
{
returnfalse;
}
}
2.bll层
///
///获得数据列表
///
publicDataSetGetList(stringstrWhere)
{
returndal.GetList(strWhere);
}
///
///获得前几行数据
///
publicDataSetGetList(intTop,stringstrWhere,stringfiledOrder)
{
returndal.GetList(Top,strWhere,filedOrder);
}
///
///删除一条数据
///
publicboolDeleteList(stringadminIDlist)
{
returndal.DeleteList(adminIDlist);
}
3.web层
(1)页面
新建页面List.aspx
<%@PageTitle="Admin"Language="C#"MasterPageFile="~/site.master"AutoEventWireup="true"CodeBehind="List.aspx.cs"Inherits="Web.List"%>
ContentID="Content2"ContentPlaceHolderID="MainContent"runat="server">
--Search-->
100%;"cellpadding="2"cellspacing="1"class="border">
80px"align="right"class="tdbg">
关键字:
TextBoxID="txtKeyword"runat="server">
TextBox>
ButtonID="btnSearch"runat="server"Text="查询"OnClick="btnSearch_Click">
Button>
增加
|
--Searchend-->
GridViewID="gridView"runat="server"AllowPaging="True"Width="100%"CellPadding="3"OnPageIndexChanging="gridView_PageIndexChanging"
BorderWidth="1px"DataKeyNames="adminID"OnRowDataBound="gridView_RowDataBound"
AutoGenerateColumns="false"PageSize="10"RowStyle-HorizontalAlign="Center"OnRowCreated="gridView_OnRowCreated">
TemplateFieldControlStyle-Width="30"HeaderText="选择">
CheckBoxID="DeleteThis"runat="server"/>
Te
展开阅读全文
相关搜索
资源标签