62,046
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace UserMS_Models
{
/// <summary>
/// 用户信息实体
/// </summary>
public class User_Entity
{
private int _userID;
public int UserID
{
get { return _userID; }
set { _userID = value; }
}
private string _userName;
public string UserName
{
get { return _userName; }
set { _userName = value; }
}
private string _userDH;
public string UserDH
{
get { return _userDH; }
set { _userDH = value; }
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using UserMS_Models;
using System.Data.SqlClient;
namespace User_Services
{
/// <summary>
/// 用户信息数据访问层
/// </summary>
public class User_Service
{
private static string strCon = "server=.;uid=sa;pwd=svse;database=..";
/// <summary>
/// 添加
/// </summary>
/// <param name="user">用户实体</param>
/// <returns>true添加成功,fals添加失败</returns>
public static bool Insert(User_Entity user)
{
string sql = "INSERT INTO ....";
SqlConnection conn = new SqlConnection(strCon);
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
int count = cmd.ExecuteNonQuery();
conn.Close();
return count > 0;
}
//修改
public static bool Update(User_Entity user)
{
//同添加
}
//删除
public static bool Delete(int uid)
{
//基本一样
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using UserMS_Models;
using User_Services;
namespace UserMS_Manage
{
/// <summary>
/// 用户信息业务逻辑层
/// </summary>
public class User_Manage
{
/// <summary>
/// 添加
/// </summary>
/// <param name="user">用户实体</param>
/// <returns>true添加成功,fals添加失败</returns>
public static bool Insert(User_Entity user)
{
return User_Service.Insert(user);
}
//修改
public static bool Update(User_Entity user)
{
//基本相同
}
//删除
public static bool Delete(int uid)
{
//基本相同
}
}
}
.cs
/// <summary>
///删除
/// </summary>
protected void grdUserInfo_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//获取用户编号
string id = this.grdUserInfo.DataKeys[e.RowIndex].Value.ToString();
User_Manage.Delete(int.Parse(id));
}
/// <summary>
/// 编辑
/// </summary>
protected void grdUserInfo_RowEditing(object sender, GridViewEditEventArgs e)
{
this.grdUserInfo.EditIndex = e.NewEditIndex;
}
/// <summary>
/// 修改
/// </summary>
protected void grdUserInfo_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//获取数据
TextBox txtName = this.grdUserInfo.Rows[e.RowIndex].Controls[1].FindControl("txtName");
string name = name.Text;
//其余数据同样找法,也可通过其他方式查找。。。
//...
//...
//将数据封装
User_Entity user = new User_Entity();
user.UserName = name;
//...
if (User_Manage.Update(user))
{
//true
}
else
{
//false
}
}
protected void grdUserInfo_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
this.grdUserInfo.EditIndex = -1;
//根据情况将数据进行重新绑定。。。
}
.aspx
<asp:GridView ID="grdUserInfo" runat="server" AutoGenerateColumns="False"
DataKeyNames="userID" onrowdeleting="grdUserInfo_RowDeleting"
onrowediting="grdUserInfo_RowEditing" onrowupdating="grdUserInfo_RowUpdating"
Width="341px" onrowcancelingedit="grdUserInfo_RowCancelingEdit">
<Columns>
<asp:BoundField DataField="userName" HeaderText="ID" />
<asp:TemplateField HeaderText="Name">
<EditItemTemplate>
<asp:TextBox ID="txtName" runat="server" ontextchanged="TextBox1_TextChanged"
Text='<%# Eval("userName") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblName" runat="server" Text='<%# Eval("userName") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="DH">
<EditItemTemplate>
<asp:TextBox ID="txtDH" runat="server" Text='<%# Eval("userDH") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblDH" runat="server" Text='<%# Eval("userDH") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:ButtonField CommandName="delete" Text="删 除" />
<asp:CommandField ShowEditButton="True" />
</Columns>
</asp:GridView>