這里開始開始：
DBServer bll = Faction.GetServer();
public bool Add(Models.Users obj)
{
string str = "insert into users values("+Comm.Addstr(obj.Usersname)+","+Comm.Addstr(obj.Pwd)+","+Comm.Addstr(obj.Del.ToString())+","+Comm.Addstr(obj.Role.ToString())+")";
int a = bll.GetInt(str);
return a == 0 || a == -1 ? false : true;
}
public bool Updata(Models.Users obj)
{
string str = "update users set usersname ="+Comm.Addstr(obj.Usersname)+", pwd="+Comm.Addstr(obj.Pwd)+", role="+Comm.Addstr(obj.Role.ToString())+"where id="+Comm.Addstr(obj.Id.ToString());
int a = bll.GetInt(str);
return a == 0 || a == -1 ? false : true;
}
public bool Del(string id)
{
string str = "update users set del=0 where id="+Comm.Addstr(id);
int a = bll.GetInt(str);
return a == 0 || a == -1 ? false : true;
}
public DataSet Qurey(string where = "")
{
string str = "select id,usersname as '用戶名',role as '權限' from users where del!=0 and usersname like "+Comm.Addstr("%"+where+"%");
DataSet set = bll.GetSet(str);
return set;
}
public Models.Users GetUsers(string id)
{
string str = "select * from users where id="+Comm.Addstr(id);
DataSet set = bll.GetSet(str);
Models.Users obj = new Models.Users();
obj.Id = Convert.ToInt16(set.Tables[0].Rows[0]["id"].ToString());
obj.Usersname = set.Tables[0].Rows[0]["usersname"].ToString();
obj.Pwd = set.Tables[0].Rows[0]["pwd"].ToString();
obj.Del = Convert.ToInt16(set.Tables[0].Rows[0]["del"].ToString());
obj.Role = Convert.ToInt16(set.Tables[0].Rows[0]["role"].ToString());
return obj;
}
public int Exestl(string users,string pwd)
{
string str = "select pwd from users where usersname=" + Comm.Addstr(users);
DataSet set = bll.GetSet(str);
if (set.Tables[0].Rows.Count < 1)
{
return 0;
}
string pwds = set.Tables[0].Rows[0]["pwd"].ToString();
if (Comm.Md5(pwd) == pwds)
{
return 2;
}
else
{
return 1;
}
}
這里結束：
樣式：
開始：
.text{
width:200px;
height:25px;
line-height:25px;
border:1px solid black;
border-radius:6px;
outline:none;
background-color:#ceec7c;
}
.btn {
width: 80px;
height: 25px;
line-height:25px;
border: 1px solid black;
border-radius: 3px;
outline: none;
background-color:#8df1f8;
}
.grid th{
text-align:center;
}
.grid td{
text-align:center;
}
結束
login開始：
<style>
body{
background-color:#8faaf5;
}
fieldset{
border:2px solid black;
border-radius:7px;
margin:100px auto;
width:450px;
height:400px;
text-align:center;
background-color:#52f540;
}
legend{
text-align:center;
}
.txt{
width:300px;
height:40px;
border:1px solid black;
border-radius:6px;
outline:none;
background-color:#fcea97;
margin-top:30px;
}
.btn{
width:304px;
height:41px;
border:1px solid black;
border-radius:6px;
outline:none;
background-color:#2df7f3;
margin-top:40px;
}
</style>
<div>
<fieldset>
<legend>登 錄</legend>
<input style="margin-top:60px" type="text" id="txtUsers" runat="server" class="txt" placeholder="輸入用戶名:" /><br />
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="用戶名不為空!" ForeColor="Red" ControlToValidate="txtUsers"></asp:RequiredFieldValidator><br />
<input type="password" id="txtPwd" runat="server" class="txt" placeholder="輸入密碼:" /><br />
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ErrorMessage="密碼不為空!" ForeColor="Red" ControlToValidate="txtPwd"></asp:RequiredFieldValidator><br />
<asp:Button ID="Button1" CssClass="btn" runat="server" Text="登 錄" OnClick="Button1_Click" />
</fieldset>
</div>
uj5u.com熱心網友回復：
我看了
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/172942.html
標籤：C#