//查询事件
protected void Button1_Click(object sender, EventArgs e)
{
string name = this.txlinkman.Text;
string login = this.txlogin.Text;
QPS.NEW.BLL.Leaveword lw =new QPS.NEW.BLL.Leaveword();
dgExamProj.DataSource = lw.SelectList("(select UserName from Users where id= a.UserID) = '" + name + "'");
dgExamProj.DataBind();
}
//查询事件
protected void Button1_Click(object sender, EventArgs e)
{
string name = this.txlinkman.Text;
string login = this.txlogin.Text;
QPS.NEW.BLL.Leaveword lw = new QPS.NEW.BLL.Leaveword();
dgExamProj.DataSource = lw.SelectList("(select UserName from Users where id= a.UserID) = '" + name + "'");
dgExamProj.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string ID = Convert.ToString(Request["id"]);
NEW.Model.Leaveword m_leaveword = new QPS.NEW.Model.Leaveword();
QPS.NEW.BLL.Leaveword lw = new QPS.NEW.BLL.Leaveword();
m_leaveword = lw.GetModel(Convert.ToInt32(ID));
this.txtTitle.Text = m_leaveword.title;
this.Content.Text = m_leaveword.Content;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
string ID =Convert.ToString(Request["id"]);
NEW.Model.Leaveword m_leaveword = new QPS.NEW.Model.Leaveword();
QPS.NEW.BLL.Leaveword lw = new QPS.NEW.BLL.Leaveword();
m_leaveword = lw.GetModel(Convert.ToInt32(ID));
this.txtTitle.Text = m_leaveword.title;
this.Content.Text = m_leaveword.Content;
}
}
/// <summary>
/// 绑定
/// </summary>
public void Bind()
{
int currentpage = Convert.ToInt32(Request["CurrentPage"]);
int check = 1;
currentpage = (currentpage < 1) ? 1 : currentpage;
if (this.Pager1.CurrentIndex > 0)
{
currentpage = this.Pager1.CurrentIndex;
}
int pageSize = this.Pager1.PageSize;
QPS.NEW.BLL.Leaveword lw = new QPS.NEW.BLL.Leaveword();
ds = lw.Select(pageSize, currentpage);
dgExamProj.DataSource = ds;
this.Pager1.ItemCount = lw.GetCount();
dgExamProj.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
QPS.NEW.BLL.Users user = new QPS.NEW.BLL.Users();
QPS.NEW.BLL.Leaveword Bleave = new QPS.NEW.BLL.Leaveword();
if (Session["username"] != null)
{
//获取Uid
string uname = Session["username"].ToString();
DataSet dsUser = user.GetList(uname);
int uid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["UserID"]);
DataSet dsInt = Bleave.GetListLocalise("UserID='" + uid + "'");
GridView1.DataSource = dsInt;
GridView1.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
QPS.NEW.BLL.Users user = new QPS.NEW.BLL.Users();
QPS.NEW.BLL.Leaveword Bleave= new QPS.NEW.BLL.Leaveword();
if (Session["username"] != null)
{
//获取Uid
string uname = Session["username"].ToString();
DataSet dsUser = user.GetList(uname);
int uid = Convert.ToInt32(dsUser.Tables[0].Rows[0]["UserID"]);
DataSet dsInt = Bleave.GetListLocalise("UserID='" + uid + "'");
GridView1.DataSource = dsInt;
GridView1.DataBind();
}
}
}
/// <summary>
/// 绑定
/// </summary>
public void Bind()
{
int currentpage = Convert.ToInt32(Request["CurrentPage"]);
int check = 1;
currentpage = (currentpage < 1) ? 1 : currentpage;
if (this.Pager1.CurrentIndex > 0)
{
currentpage = this.Pager1.CurrentIndex;
}
int pageSize = this.Pager1.PageSize;
QPS.NEW.BLL.Leaveword lw = new QPS.NEW.BLL.Leaveword();
ds = lw.Select(pageSize, currentpage);
dgExamProj.DataSource = ds;
this.Pager1.ItemCount = lw.GetCount();
dgExamProj.DataBind();
}
//生成事件时激发
protected void dgExamProj_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.CommandName == "delete")//删除
{
string ID = e.CommandArgument.ToString();
QPS.NEW.BLL.Leaveword lw = new QPS.NEW.BLL.Leaveword();
if (lw.Delete(int.Parse(ID)))
{
Response.Write("<script>alert('删除成功!');</script>");
}
Bind();
}
if (e.CommandName == "LinkTo")//查看
{
string ID = e.CommandArgument.ToString();
Server.Transfer("LeaveWordXq.aspx?id=" + ID);
}
}
//生成事件时激发
protected void dgExamProj_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.CommandName == "delete")//删除
{
string ID = e.CommandArgument.ToString();
QPS.NEW.BLL.Leaveword lw = new QPS.NEW.BLL.Leaveword();
if (lw.Delete(int.Parse(ID)))
{
Response.Write("<script>alert('删除成功!');</script>");
}
Bind();
}
if (e.CommandName == "LinkTo")//查看
{
string ID = e.CommandArgument.ToString();
Server.Transfer("LeaveWordXq.aspx?id=" + ID);
}
}
