实现用户管理模块和新闻类别管理模块

最新推荐文章于 2022-06-30 14:49:40 发布

泼墨挥毫

最新推荐文章于 2022-06-30 14:49:40 发布

阅读量610

点赞数

文章标签： c# sql server

本文链接：https://blog.csdn.net/ln838419224/article/details/8669976

版权

实现用户管理模块

前台

<body>
<form id="form1" runat="server">
<div>
<table style="width: 48%;">
<tr>
<td>
 
用户编号：</td>
<td>
 
<asp:TextBox ID="txtyhbh" runat="server"></asp:TextBox>
 </td>

</tr>
<tr>
<td>
 
帐号：</td>
<td>
 
<asp:TextBox ID="txtUserName" runat="server"></asp:TextBox>
</td>

</tr>
<tr>
<td>
 
密码：</td>
<td>
 
<asp:TextBox ID="txtPassword" runat="server"></asp:TextBox>
</td>

</tr>
<tr>
<td class="style1">
 
用户名称：</td>
<td class="style1">
 
<asp:TextBox ID="txtName" runat="server"></asp:TextBox>
</td>

</tr>
<tr>
<td>
 
手机：</td>
<td>
 
<asp:TextBox ID="txtPhone" runat="server"></asp:TextBox>
</td>

</tr>
<tr>
<td>
 
所属部门：</td>
<td>
 
<asp:DropDownList ID="ddlssbm" runat="server" AutoPostBack="True">
</asp:DropDownList>
</td>

</tr>
<tr><td>
<asp:Button ID="userAdd" runat="server" Xοnclick="userAdd_Click" Text="添加用户" />
</td><td>

</td></tr>
</table>
<hr color="red"/>
<asp:DropDownList ID="ddldeleteuser" runat="server" AutoPostBack="True">
</asp:DropDownList>
<asp:Button ID="userDelete" runat="server" Text="删除用户"
Xοnclick="userDelete_Click" />
</div>
</form>
</body>

后台

public partial class UsersAdd : System.Web.UI.Page
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
string yhbh = string.Empty;
string UserName = string.Empty;
string Password = string.Empty;
string Name = string.Empty;
string Phone = string.Empty;
string department = string.Empty;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (SqlConnection conn = new SqlConnection(constr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select Department_Id,Department_Name from Department";
SqlDataAdapter adapter = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();
adapter.Fill(dt);
ddlssbm.DataSource = dt;
ddlssbm.DataTextField = "Department_Name";
ddlssbm.DataValueField = "Department_Id";
//ddlClassCreator.SelectedValue.ToString();
ddlssbm.DataBind();

}
}
using (SqlConnection conn = new SqlConnection(constr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select UserId,RealName from T_User";
using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
adapter.Fill(dt);
ddldeleteuser.DataSource = dt;
ddldeleteuser.DataTextField = "RealName";
ddldeleteuser.DataValueField = "UserId";
ddldeleteuser.DataBind();
}
}
}
}
}

protected void userAdd_Click(object sender, EventArgs e)
{
yhbh = txtyhbh.Text;
UserName = txtUserName.Text;
Password = txtPassword.Text;
Name = txtName.Text;
Phone = txtPhone.Text;
department = ddlssbm.SelectedItem.Value;
using (SqlConnection conn = new SqlConnection(constr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "insert into T_User values(@Id,@UserId,@UserName,@Password,@RealName,@Department)";
cmd.Parameters.Add(new SqlParameter("@Id", yhbh));
cmd.Parameters.Add(new SqlParameter("@UserId", UserName));
cmd.Parameters.Add(new SqlParameter("@UserName", Password));
cmd.Parameters.Add(new SqlParameter("@Password", Name));
cmd.Parameters.Add(new SqlParameter("@RealName", Phone));
cmd.Parameters.Add(new SqlParameter("@Department", department));
if (cmd.ExecuteNonQuery() > 0)
{
Response.Write("添加用户成功！");
}

}
}
}

protected void userDelete_Click(object sender, EventArgs e)
{
string deleteuser =ddldeleteuser.SelectedItem.Value;
using (SqlConnection conn = new SqlConnection(constr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "declare @abc int;set @abc=@userid;delete T_User where UserId=@abc;delete T_News where NewsCreator=@abc;";
cmd.Parameters.Add(new SqlParameter("@userid", deleteuser));
if (cmd.ExecuteNonQuery() > 0)
{
Response.Write("<script type=\"text/javascript\">alert('删除成功！');</script>");
}
}
}
}
}

新闻类别管理模块

前台

<body>
<form id="form1" runat="server">
<div>

类别名称：<asp:TextBox ID="txtNewsClass" runat="server"></asp:TextBox>
<br />
创建者：<asp:DropDownList ID="ddlClassCreator" runat="server" AutoPostBack="True">
</asp:DropDownList>
<br />
类别名称：<asp:DropDownList ID="ddlClassName" runat="server" AutoPostBack="True">
</asp:DropDownList>
<br />
<asp:Button ID="btnAdd" runat="server" Xοnclick="btnAdd_Click" Text="添加" />
<asp:Button ID="btndelete" runat="server" Xοnclick="btndelete_Click" Text="删除" />
<asp:Button ID="btndeleteNew" runat="server" Xοnclick="btndeleteNew_Click"
Text="删除相关新闻" />

</div>
</form>
</body>

后台

public partial class NewsClassAdd : System.Web.UI.Page
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
string classid = string.Empty;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//添加创建者
using (SqlConnection conn = new SqlConnection(constr))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select UserId,RealName from T_User";
SqlDataAdapter adapter2 = new SqlDataAdapter(cmd);

DataTable dtUser = new DataTable();
adapter2.Fill(dtUser);
ddlClassCreator.DataSource = dtUser;
ddlClassCreator.DataTextField = "RealName";
ddlClassCreator.DataValueField = "UserId";
//ddlClassCreator.SelectedValue.ToString();
ddlClassCreator.DataBind();

}
}

//添加类别下拉框
using (SqlConnection conn = new SqlConnection(constr))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select ClassId,ClassName from T_NewsClass";
SqlDataAdapter adapter = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();
adapter.Fill(dt);
ddlClassName.DataSource = dt;
ddlClassName.DataTextField = "ClassName";
ddlClassName.DataValueField = "ClassId";
//ddlClassCreator.SelectedValue.ToString();
ddlClassName.DataBind();

}
}
}
}

protected void btnAdd_Click(object sender, EventArgs e)
{
string classname=txtNewsClass.Text.Trim();
//string classcreator = ddlClassCreator.SelectedValue.ToString();
string classcreator = ddlClassCreator.SelectedItem.Value;

using (SqlConnection conn = new SqlConnection(constr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "insert into T_NewsClass values(NEWID(),@ClassName,@ClassCreator,GETDATE())";
cmd.Parameters.Add(new SqlParameter("@ClassName", classname));
cmd.Parameters.Add(new SqlParameter("@ClassCreator", classcreator));
if (cmd.ExecuteNonQuery() > 0)
{
Response.Write("添加类别成功！");
}
}
}
}

protected void btndelete_Click(object sender, EventArgs e)
{
classid = ddlClassName.SelectedItem.Value;
using (SqlConnection conn = new SqlConnection(constr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "delete T_NewsClass where ClassId=@classid";
cmd.Parameters.Add(new SqlParameter("@classid", classid));

if (cmd.ExecuteNonQuery() > 0)
{
Response.Write("删除类别成功！");
}

}
}

}

protected void btndeleteNew_Click(object sender, EventArgs e)
{
classid = ddlClassName.SelectedItem.Value;
using (SqlConnection conn = new SqlConnection(constr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "delete T_News where ClassId=@classid";
cmd.Parameters.Add(new SqlParameter("@classid", classid));
if (cmd.ExecuteNonQuery() > 0)
{
Response.Write("删除该类别新闻成功！");
}
}
}
}
}