三层框架中单表的增删改查

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
using Model.ruanmou;
using DAL.ruanmou;
using com.DAL.Base;
namespace vip20180206
{
public partial class demo : System.Web.UI.Page
{

protected void Page_Load(object sender, EventArgs e)
{

}

protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
string qq = txtQQ.Text.Trim();
string pwd = txtPwd.Text.Trim();
if (string.IsNullOrEmpty(qq) || string.IsNullOrEmpty(pwd))
{
Response.Write("qq和密码不能为空");
}
else
{
List<dbParam> listPm = new List<dbParam>(){
new dbParam(){ ParamName="@qq", ParamValue=qq},
new dbParam(){ ParamName="@pwd", ParamValue=pwd}
};
//UserInfor user = UserInforDal.m_UserInforDal.GetModel("qq=@qq and pwd=@pwd",listPm);//获取到一个对象
int count = UserInforDal.m_UserInforDal.GetCount("qq=@qq and pwd=@pwd", listPm);//获取到一个记录数
if (count > 0)
{
Response.Write("登录成功");
}
else
{
Response.Write("用户名或密码错误");
}
//if (user == null)
//{
// Response.Write("用户名或密码错误");
//}
//else
//{
// Response.Write("登录成功");
//}
}
}
catch (Exception ex)
{
Response.Write("网站维修中..");
}
}

protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
string realname = txtARealName.Text.Trim();
string tel = txtAPhoneNum.Text.Trim();
string qq = txtAQQ.Text.Trim();
string niclname = txtANickName.Text.Trim();
string createdtime = txtACreatedTime.Text.Trim();
string pwd = txtAPwd.Text.Trim();
if (string.IsNullOrEmpty(tel) || string.IsNullOrEmpty(qq) || string.IsNullOrEmpty(pwd))
{
Response.Write("手机号、qq、密码不能为空");
}
else
{
UserInfor user = new UserInfor();
user.RealName = realname;
user.PhoneNum = tel;
user.QQ = qq;
user.NickName = niclname;
user.CreatedTime = Convert.ToDateTime(createdtime);
if (UserInforDal.m_UserInforDal.Add(user) > 0)
{
Response.Write("注册成功");
}
else
{
Response.Write("注册失败");
}
}
}
catch (Exception ex)
{
Response.Write("网站维修中....");
}
}

protected void btnDel_Click(object sender, EventArgs e)
{
try
{
int userid =Convert.ToInt32(txtDUserId.Text.Trim());

if (string.IsNullOrEmpty(txtDUserId.Text.Trim()))
{
Response.Write("用户ID不能为空");
}
else
{
List<dbParam> listPm = new List<dbParam>(){
new dbParam(){ ParamName="@userid", ParamValue=userid}
};
UserInfor user = UserInforDal.m_UserInforDal.GetModel("UserId=@userid", listPm);
if (user != null)
{
if (UserInforDal.m_UserInforDal.Delete("UserId=@userid", listPm) > 0)
{
Response.Write("删除成功");
}
else {
Response.Write("删除失败");
}
}
else
{
Response.Write("该用户不存在");
}
}
}
catch (Exception ex)
{
Response.Write("网站维修中....");
}
}

protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
int userid =Convert.ToInt32(txtUUserId.Text.Trim());
string qq = txtUQQ.Text.Trim();
List<dbParam> listPm = new List<dbParam>(){
new dbParam(){ ParamName="@userid", ParamValue=userid}
};
UserInfor user = UserInforDal.m_UserInforDal.GetModel("UserId=@userid", listPm);
if (user != null)
{
user.QQ = qq;
if (UserInforDal.m_UserInforDal.Update(user))
{
Response.Write("更新成功");
}
else
{
Response.Write("更新失败");
}
}
else {
Response.Write("该用户不存在");
}
}
catch (Exception ex)
{
Response.Write("网站维修中....");
}
}
}
}