bill.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>
/// bill 的摘要说明
/// </summary>
public class bill
{
	public bill()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public DataTable depidinfo(string id,Page p)
    {
        string sql = "select * from department where depid="+id;
        DataTable table = GenericDataAccess.ExecuteSelectCommand(sql,p);
        return table;
    }

    //返回制定医院制定用户的未付消费
    public DataTable conhpunpay(string hosid, string perid, Page p)
    {
        string sql = "select * from consume where perhosid="+hosid+" and personid="+perid+" and payed is null";
        DataTable table = GenericDataAccess.ExecuteSelectCommand(sql, p);
        return table;
    }
    //返回制定药店指定用户的未付款消费
    public DataTable condsunpay(string drugstoreid, string perid, Page p)
    {
        string sql = "select * from consume where drugstoreid="+drugstoreid+" and personid="+perid+" and payed is null";
        DataTable table = GenericDataAccess.ExecuteSelectCommand(sql, p);
        return table;
    }
    //由系统管理员id求药店id
    public DataTable adminidtodrugstoreid(string id,Page p)
    {
        admin a=new admin ();
       DataTable b= a.idinfo(id,p);
       string name = b.Rows[0]["adminname"].ToString();
       string sql = "select * from drugstore where drugstorename='" + name + "'";
       return GenericDataAccess.ExecuteSelectCommand(sql, p);
    }
    //由系统管理员id求医院id
    public DataTable adminidtohosid(string id, Page p)
    {
        admin a = new admin();
        DataTable b = a.idinfo(id,p);
        string name = b.Rows[0]["adminname"].ToString();
        string sql = "select * from hospital where hosname='" + name + "'";
        return GenericDataAccess.ExecuteSelectCommand(sql, p);
    }
}