editdrug.aspx.cs

医院的用户管理与缴费与当病人去医院看病的时候要挂号等作用。

using System;
using System.Data;
using System.Data.Common;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class OrganizationSys_editdrug : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            dblind();
        }
    }
    public void dblind()
    {
        int curpage = Convert.ToInt32(this.labpage.Text);
        PagedDataSource alldrug = new PagedDataSource();
        alldrug.DataSource = Alldrug(Page).DefaultView;
        alldrug.AllowPaging = true;
        alldrug.PageSize = 20;
        alldrug.CurrentPageIndex = curpage - 1;
        this.lnkbtback.Enabled = true;
        this.lnkbtnext.Enabled = true;
        this.lnkbtnone.Enabled = true;
        this.lnkbtup.Enabled = true;
        if (curpage == 1)
        {
            this.lnkbtnone.Enabled = false;
            this.lnkbtup.Enabled = false;
        }
        if (curpage == alldrug.PageCount)
        {
            this.lnkbtnext.Enabled = false;
            this.lnkbtback.Enabled = false;
        }
        this.labback.Text = Convert.ToString(alldrug.PageCount);
        DataList1.DataSource = alldrug;
        DataList1.DataKeyField = "drugid";
        DataList1.DataBind();
    }

    protected void lnkbtone_click(object sender, EventArgs e)
    {
        labpage.Text = "1";
        dblind();
    }
    protected void lnktbnup_click(object sender, EventArgs e)
    {
        labpage.Text = Convert.ToString(Convert.ToInt32(labpage.Text) - 1);
        dblind();
    }
    protected void lnkbtnnext_click(object sender, EventArgs e)
    {
        labpage.Text = Convert.ToString(Convert.ToInt32(labpage.Text) - 1);
        dblind();
    }
    protected void lnkbtback_click(object sender, EventArgs e)
    {
        labpage.Text = labback.Text;
        dblind();
    }
    private DataTable Alldrug(Page p)
    {
        string sql = "select * from [drug] order by drugid desc";
        DataTable table = GenericDataAccess.ExecuteSelectCommand(sql, p);
        return table;
    }



    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Redirect("Default.aspx");
    }
}