数学与计算机科学学院毕业设计
///
/// ///
public AdminInfo GetSingleAdminInfo(string username) {
SqlParameter[] parameters = {
new (\arChar ,50) }; parameters[0].Value = username; SqlDataReader sdr;
AdminInfo admin = new AdminInfo(); try { sdr parameters); {
admin.Id = Convert.ToInt32(sdr[\ admin.Pwd = sdr[\
admin.UserName = sdr[\ }
return admin; }
catch (Exception ex) {
throw new Exception(ex.Message); } }
#endregion BLL层
public bool Exists(string username) {
return adminsql.Exists(username); }
public AdminInfo GetSingleAdminInfo(string username) {
return adminsql.GetSingleAdminInfo(username); }
5.2 系统主界面
登录成功后进入主界面可以从这个界面进入相关操作,主界面如图5-3所示。
26
SqlParameter
= sqlhelper.ExecuteDataReader(\
while (sdr.Read())
数学与计算机科学学院毕业设计
图5-3 系统主界面
主界面主要链接各个模块，在待入院模块中，在病人挂号查询拟住院日期时主要是用挂号时间加上病人未入院的那段时间，这个根据每个医院不同的情况而定。
5.3 系统模块设计
以下为住院病人信息管理模块的代码设计： using System;
using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI;
using System.Web.UI.HtmlControls; using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using Model; using BLL;
public partial class IllerList : System.Web.UI.Page {
IllBedBLL illbedbll = new IllBedBLL(); IllerInfoBLL illerinfobll = new IllerInfoBLL(); protected void Page_Load(object sender, EventArgs e) {
if (!IsPostBack) {
lblBedTotalNum.Text = Convert.ToString(illbedbll.SelectBedInfo());
27
数学与计算机科学学院毕业设计
lblUsedBed.Text = Convert.ToString(illbedbll.SelectBedInfo()); AspNetPager1.RecordCount = illerinfobll.AllIllerInfoCount(); Bind(); } }
public void Bind() {
DataSet
GridView1.DataSource = ds; GridView1.DataBind(); }
protected void AspNetPager1_PageChanged(object sender, EventArgs e) {
Bind(); }
protected void Button1_Click(object sender, EventArgs e) {
if (txt_search.Text != null || txt_search.Text != \ {
Response.Write(\\
}
else {
commom.MessageAlert(\请输入要查询的病人信息！\ } } }
BLL层代码
public DataSet AllIllerInfo(int nStartIndex, int nEndIndex) {
return (DataSet)illerinfosql.AllIllerInfo(nStartIndex, nEndIndex); } DAL层：
///
/// 增加一条数据 ///
public int Add(IllerInfo iller) {
SqlParameter[] parameters = {
ds =
illerinfobll.AllIllerInfo(AspNetPager1 .StartRecordIndex ,AspNetPager1 .EndRecordIndex );
new SqlParameter(\arChar,50), new SqlParameter(\arChar,10), new SqlParameter(\
new SqlParameter(\arChar,50),
28
数学与计算机科学学院毕业设计
new SqlParameter(\new SqlParameter(\
new SqlParameter(%uanTime\ }; parameters[0].Value = iller.PatientName; parameters[1].Value = iller.Sex; parameters[2].Value = iller.Age; parameters[3].Value = iller.Illtype;
parameters[4].Value = iller.InOrNotHospital; parameters[5].Value = iller.ZhuyuanTime; parameters[6].Value = iller.ChuYuanTime;
return (int)sqlHelper.ExecuteNonQuery(\ }
public DataSet AllIllerInfo(int nStartIndex, int nEndIndex) {
SqlParameter[] parameters = {
new (\
new (\
}; parameters[0].Value = nStartIndex; parameters[1].Value = nEndIndex;
string str = \
DataSet ds = sqlHelper.ExecuteDataSet(str, parameters); return ds;
}
public int AllIllerInfoCount() {
string str = \ int result = Convert.ToInt32(sqlHelper.ExecuteScalar(str)); return result; }
public int IllerInfoByName(string username) {
string str = \as counts from IllerInfo where PatientName='\+ username + \
SqlParameter[] parameters = { new (\arChar ,50) }; parameters[0].Value = username;
int result = Convert.ToInt32(sqlHelper.ExecuteScalar(str, parameters)); return result; }
29
SqlParameter SqlParameter
SqlParameter
数学与计算机科学学院毕业设计
SqlHelper类，主要是封装的各种方法，代码如下：
public class SQLHelper {
private static readonly string connString =
ConfigurationManager.AppSettings[\ private SqlConnection cn; public SQLHelper()
{
cn = new SqlConnection(connString); }
public int ExecuteNonQuery(string query) {
using (cn = new SqlConnection(connString)) {
cn.Open();
SqlCommand cmd = new SqlCommand(query, cn); if
(query.StartsWith(\
|
query.StartsWith(\TE\
query.StartsWith(\| query.StartsWith(\| query.StartsWith(\query.StartsWith(\
{
cmd.CommandType = CommandType.Text; } else {
cmd.CommandType = CommandType.StoredProcedure; } try {
cmd.ExecuteNonQuery(); }
catch (Exception ex)
{
throw new Exception(ex.Message); }
finally {
cn.Close(); }
return (int)cmd.ExecuteNonQuery(); }
}
public int ExecuteNonQuery(string query, SqlParameter[] parameters) {
30
|
|