public void TestMethod1()
{
var rep = new UserInfoRep();
rep.Insert(new UserInfoMo()
{
nick_name = "再次测试"
});
}
public void UserTest()
{
var mo = new UserInfoMo
{
email = "*****@*****.**",
mobile = "1111111111"
};
var rep = new UserInfoRep();
var res = rep.Add(mo);
mo.id = res.Id;
mo.email = "*****@*****.**";
mo.mobile = "222222222222";
}
public void UserTest()
{
var mo = new UserInfoMo
{
email = "*****@*****.**",
mobile = "1111111111"
};
var rep = new UserInfoRep();
var res = rep.Insert(mo);
mo.Id = res.Id;
mo.email = "*****@*****.**";
mo.mobile = "222222222222";
rep.UpdateAll(mo); // 全量更新测试
rep.Update(mo, m => new { m.email }, m => m.Id == 1); // 部分更新
rep.DeleteSoft(mo); // 软删除
rep.Get(mo, m => m.Id == 16); // 查询
}
public void get_datatable()
{
//数据库连接字符串
//string strconn = System.Configuration.ConfigurationManager.AppSettings["MovieConnectionString"];
//实例化连接对象，并赋值strconn
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["MovieConnectionString"].ConnectionString);
//打开连接对象
conn.Open();
//临时存储
// DataTable Temp_dt = new DataTable();
DataSet ds = new DataSet();
//实例化数据库适配器
SqlDataAdapter Dad = new SqlDataAdapter("select * from[Table]", conn);
//填充
Dad.Fill(ds, "t");
PagedDataSource pds = new PagedDataSource();
pds.DataSource = ds.Tables["t"].DefaultView;
pds.AllowPaging = true;
pds.PageSize = 1;
pds.CurrentPageIndex = 1;
//********
int CurPage;
if (Request.QueryString["Page"] != null)
{
CurPage = Convert.ToInt32(Request.QueryString["Page"]);
}
else
{
CurPage = 1;
}
pds.CurrentPageIndex = CurPage - 1;
int Count = pds.PageCount;
lblMssg.Text = "当前页：" + CurPage.ToString();
lblPage.Text = Count.ToString();
if (!pds.IsFirstPage)
{
this.first.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1";
this.last.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(Count - 1);;
up.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);
}
else
{
this.first.Visible = false;
this.last.Visible = false;
}
if (!pds.IsLastPage)
{
next.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);
}
else
{
this.first.Visible = false;
this.last.Visible = false;
}
//********
UserInfoRep.DataSource = pds;
UserInfoRep.DataBind();
//关闭连接对象
//conn.Close();
//释放连接对象资源
//conn.Dispose();
//返回DataTable
//return pds;
}
