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)
        {
            if (!IsPostBack)
            {
                if (Session["id"].ToString() != "")
                {
                    string id = Session["id"].ToString();
                    string type = Session["type"].ToString();
                    string name = Session["name"].ToString();
                    string psw = Session["psw"].ToString();
                    dblind();
                }
            }
            else
            {
                Response.Redirect("~/error.aspx");
            }
        }

    }
   
    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 selectall(object sender, EventArgs e)//全选按钮的设置
    {
        CheckBox all = sender as CheckBox;
        if (all.Checked == true)
        {
            for (int i = 0; i < DataList1.Items.Count; i++)
            {
                CheckBox cb = DataList1.Items[i].FindControl("del") as CheckBox;
                cb.Checked = true;
                cb.Enabled = false;
            }
        }
        else
        {
            for (int i = 0; i < DataList1.Items.Count; i++)
            {
                CheckBox cb = DataList1.Items[i].FindControl("del") as CheckBox;
                cb.Checked = false;
                cb.Enabled = true;
            }
        }
    }
    //删除
    protected void Button2_Click(object sender, EventArgs e)
    {
        
        for (int i = 0; i < DataList1.Items.Count; i++)
        {
            CheckBox cb = DataList1.Items[i].FindControl("del") as CheckBox;
            if (cb.Checked == true)
            {
                Label hf = DataList1.Items[i].FindControl("drugid") as Label;
                int id = Convert.ToInt32(hf.Text);
                deldrug(id, Page);
            }
        }
        dblind();
    }

    private void deldrug(int drugid,Page p)
    {
        string sql = "delete from [drug] where drugid='" + drugid + "'";
        GenericDataAccess.ExecuteNonQuery(sql, p);
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Redirect("Default.aspx");
    }
}