admin.cs

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

using System;
using System.Data;
using System.Configuration;
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;

/// <summary>
/// admin 的摘要说明
/// </summary>
public class admin
{
	public admin()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public bool Chkadmin(String name, String password, Page p)//审核管理员用户
    {

        string sql = "Select * from adminuser where adminname='" + name + "' and adminpwd='" + password + "' order by adminid asc";

        DataTable table = GenericDataAccess.ExecuteSelectCommand(sql, p);

        if (table.Rows.Count > 0)
        {

            return true;

        }
        return false;
        // return department details


    }

    public DataTable ReInfo(string name, String password, Page p)
    {
        string sql = "Select * from adminuser where adminname='" + name + "' and adminpwd='" + password + "' order by adminid asc";

        DataTable table = GenericDataAccess.ExecuteSelectCommand(sql, p);
        return table;

    }

    public DataTable idinfo(string id, Page p)
    {
        string sql = "select * from adminuser where adminid=" + id;
        DataTable table = GenericDataAccess.ExecuteSelectCommand(sql,p);
        return table;
    }
}