客车网上售票系统--查询、添加用户

1、今日完成任务:

(1)用户管理界面

(2)查询用户列表
(3)添加新用户

2、核心源码:

DAL层：

/// <summary>
/// 根据用户名查询用户信息
/// </summary>
/// <param name="uname">用户名</param>
/// <returns>用户信息</returns>
public object selectUserInfo(string username = null)
{
object userinfo = null;
if (username != null)
{
userinfo = (from a in db.userInfo
where a.uname.Contains(username) && a.type == 0
select new
{
a.ID,
a.uname,
a.upassword,
a.realname,
a.sex,
a.age,
a.tel,
a.addr,
a.delstatus,
type = "用户"
}).ToList();
}
else
{
userinfo = (from a in db.userInfo
where a.type == 0
select new
{
a.ID,
a.uname,
a.upassword,
a.realname,
a.sex,
a.age,
a.tel,
a.addr,
a.delstatus,
type = "用户"
}).ToList();
}
return userinfo;
}

/// <summary>
/// 新增用户信息
/// </summary>
/// <param name="u">用户实体</param>
/// <returns>是否新增成功true/false</returns>
public bool AddUserInfo(userInfo u)
{
int count = db.userInfo.Count(); //初始用户数量
db.userInfo.InsertOnSubmit(u); //新增
db.SubmitChanges(); //提交并更改数据库
if (count < db.userInfo.Count()) //如果初始用户数量 < 新增后数量
{
return true;
}
else
{
return false;
}
}

 

表示层：

//查询所有用户信息列表
public void getInfo()
{
this.GridView1.DataSource = bll.selectUserInfo();
this.GridView1.DataBind();
this.GridView1.RowStyle.HorizontalAlign = HorizontalAlign.Center;
}

//添加用户
protected void btn_submit_Click(object sender, EventArgs e)
{
//实例化用户对象
userInfo u = new userInfo();
u.uname = txt_uname.Text;
u.upassword = txt_pwd.Text;
u.realname = txt_realname.Text;
u.sex = rb_sex.SelectedValue;
u.age = Convert.ToInt32(txt_age.Text);
u.tel = txt_tel.Text;
u.addr = txt_addr.Text;
u.delstatus = false;
u.type = 0;

//判断是否新增成功
if(bll.AddUserInfo(u))
{
//添加成功，关闭添加窗体，刷新父窗体
Response.Write(@"<script>alert('添加成功！');
window.parent.location.reload();
var index = parent.layer.getFrameIndex(window.name);
parent.layer.close(index);
</script>");

}
else
{
Response.Write("<script>添加失败！</script>");
}
}

3、遇到的问题:

4、解决的方法:

5、项目燃尽图更新(此内容一周已更新)