protected void Page_Load(object sender, EventArgs e)
{
string name = Request.Params["name"];
if (!string.IsNullOrEmpty(name))
{
DoctorModel doctor = DoctorDAL.GetByName(name);
if (doctor != null)
{
lbl_username.Text = doctor.Name;
lbl_realname.Text = doctor.RealName;
HospitalModel hospital = HospitalDAL.GetById((long)doctor.Hospital_id);
if (hospital != null)
{
lbl_hospital.Text = hospital.Name;
lbl_hospitalPos.Text = hospital.Address;
}
string imageUrl = string.Format("~/ImageWebForm.aspx?picName={0}&fileType=doctor", doctor.PhotoPath);
graphPlaceHolder.Controls.Add(new Image()
{
ImageUrl = imageUrl, Width = 114, Height = 150
});
}
}
}
public bool GetPatientDetailByPatientID(int patientID, out Patient patient)
{
patient = new Patient();
DataTable dt;
bool patientExist = false;
dataAccessLayer = new HospitalDAL();
try
{
dt = dataAccessLayer.getPatientByID(patientID);
if (null != dt && dt.Rows.Count > 0)
{
patient.Name = dt.Rows[0]["PatientName"].ToString();
patient.ContactNumber = dt.Rows[0]["PatientContactNumber"].ToString();
patient.Address = dt.Rows[0]["PatientAddress"].ToString();
patient.DateOfBirth = Convert.ToDateTime(dt.Rows[0]["PatientDOB"].ToString());
patient.Gender = (Gender)Enum.Parse(typeof(Gender), dt.Rows[0]["PatientGender"].ToString());
patientExist = true;
}
}
catch (HospitalException ex)
{
throw ex;
}
return(patientExist);
}
// GET: Hospital
public ActionResult ListOfHospitals()
{
var list = new HospitalDAL().ListOfRecords();
ViewData["listOfData"] = list;
return(View());
}
public void ProcessRequest(HttpContext context)
{
//发送过来地区信息 hat_area的主键id(int)
//返回本地区的所有医院
StreamReader reader = new StreamReader(context.Request.InputStream, Encoding.UTF8);
string requestStr = reader.ReadToEnd();
int id;
List <HospitalModel> hospitals = new List <HospitalModel>();
if (int.TryParse(requestStr, out id))
{
hospitals.AddRange(HospitalDAL.GetAllByAreaId(id));
}
//组装医院集合的JSON数组（只有医院id和医院名称）
JObject jObj = new JObject();
jObj.Add("count", hospitals.Count);
JArray jArr = new JArray();
foreach (var hospital in hospitals)
{
JObject jObjHospital = new JObject();
jObjHospital.Add("hospital_id", hospital.Hospital_id);
jObjHospital.Add("name", hospital.Name);
jArr.Add(jObjHospital);
}
jObj.Add("content", jArr);
byte[] buf = Encoding.UTF8.GetBytes(jObj.ToString());
context.Response.OutputStream.Write(buf, 0, buf.Length);
}
public UnifyApiResult FindPageList(string name, int currentPageIndex, int pageSize)
{
HospitalDAL dal = new HospitalDAL();
IEnumerable <dynamic> result = dal.FindPageList(name, currentPageIndex, pageSize, out var total);
var enumerable = result as dynamic[] ?? result.ToArray();
return(UnifyApiResult.PageResult(enumerable, total));
}
public void AddandGetPerson_ThreeDifferentPersons_ShouldPass(Person person)
{
var dataStorage = new HospitalDAL(_dataProvider, _connectionString);
dataStorage.AddPerson(person);
int personsCount = dataStorage.GetPersons(person.FirstName, person.LastName, person.PolicyNumber).Count;
Assert.True(personsCount >= 1);
}
public void AddandGetTemplate_TwoTemplates_ShouldPass(Template template)
{
var dataStorage = new HospitalDAL(_dataProvider, _connectionString);
dataStorage.AddTemplate(template);
Template expected = dataStorage.GetTemplate(template.Title);
Assert.NotEqual(expected, null);
}
public void AddandGetAnalyzes_TwoAnalyzes_ShouldPass(string policyNumber, Analysis analysis)
{
var dataStorage = new HospitalDAL(_dataProvider, _connectionString);
dataStorage.AddAnalysis(policyNumber, analysis);
int analyzesCount = dataStorage.GetAnalyzes(policyNumber).Count;
Assert.True(analyzesCount >= 1);
}
// GET: Hospital/Create
public ActionResult AddHospital(int?Hospital_id)
{
var model = new tblHospital();
if (Hospital_id != null)
{
model = new HospitalDAL().SingleRecord(Convert.ToInt32(Hospital_id));
}
return(View(model));
}
public void GetTemplates_DBWithValues_ShouldPass()
{
var dataStorage = new HospitalDAL(_dataProvider, _connectionString);
dataStorage.AddTemplate(new Template(new List <string> {
"alcohol", "drugs"
}, "Alcho2 Test"));
int templatesCount = dataStorage.GetTemplates().Count;
Assert.True(templatesCount >= 1);
}
public UnifyApiResult Remove(string id)
{
if (string.IsNullOrEmpty(id))
{
return(UnifyApiResult.Error("参数不能为空。"));
}
HospitalDAL dal = new HospitalDAL();
dynamic result = dal.Remove(id);
return(UnifyApiResult.Sucess(result));
}
public Boolean Update(HospitalENT entHospital)
{
HospitalDAL dalHospital = new HospitalDAL();
if (dalHospital.Update(entHospital))
{
return(true);
}
else
{
Message = dalHospital.Message;
return(false);
}
}
public int AddPatient(Patient patient)
{
int patientId = 0;
dataAccessLayer = new HospitalDAL();
try
{
patientId = dataAccessLayer.AddPatient(patient);
}
catch (HospitalException ex)
{
throw ex;
}
return(patientId);
}
public UnifyApiResult Edit(HospitalModel model)
{
if (model == null)
{
return(UnifyApiResult.Error("参数不能为空。"));
}
if (string.IsNullOrEmpty(model.HName))
{
return(UnifyApiResult.Error("医院名称不能为空。"));
}
model.ModifyDate = DateTime.Now;
HospitalDAL dal = new HospitalDAL();
dynamic result = dal.Modify(model);
return(UnifyApiResult.Sucess(result));
}
public MainWindow()
{
InitializeComponent();
string connectionString = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
string dataProvider = ConfigurationManager.AppSettings["provider"];
try
{
_dataAccessLayer = new HospitalDAL(dataProvider, connectionString);
}
catch (InvalidOperationException ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
Environment.Exit(-1);
}
_canvasPainter = new CanvasPainter(MainCanvas);
}
public void ProcessRequest(HttpContext context)
{
//发过来医院的主键，返回医院的详细信息
StreamReader reader = new StreamReader(context.Request.InputStream, Encoding.UTF8);
string requestStr = reader.ReadToEnd();
long hospital_id;
string json = null;
if (!long.TryParse(requestStr, out hospital_id))
{
//这是移动端的
JObject jObj = JObject.Parse(requestStr);
string hospitalName = jObj["name"].ToString();
string locStr = jObj["citycode"].ToString();
if (HospitalDAL.Find(hospitalName, LocationDAL.GetCityId(locStr), out hospital_id))
{
HospitalModel hospital = HospitalDAL.GetById(hospital_id);
JObject jResponse = new JObject();
jResponse.Add("name", hospital.Name);
jResponse.Add("address", hospital.Address);
jResponse.Add("introduction", hospital.Introduction);
json = jResponse.ToString();
}
else
{
return;
}
}
else
{
//这是医生端的
HospitalModel hospital = HospitalDAL.GetById(hospital_id);
json = JsonConvert.SerializeObject(hospital);
}
byte[] buf = Encoding.UTF8.GetBytes(json);
context.Response.OutputStream.Write(buf, 0, buf.Length);
}
public void ProcessRequest(HttpContext context)
{
StreamReader reader = new StreamReader(context.Request.InputStream, Encoding.UTF8);
string requestStr = reader.ReadToEnd();
JObject jObj = JObject.Parse(requestStr);
long doc_id;
JObject jResponse = new JObject();
if (long.TryParse(jObj["doc_id"].ToString(), out doc_id))
{
var doctor = DoctorDAL.GetById(doc_id);
jResponse.Add("id", doctor.Name);
jResponse.Add("name", doctor.RealName);
jResponse.Add("introduction", doctor.Introduction);
jResponse.Add("hospital", HospitalDAL.GetById((long)doctor.Hospital_id).Name);
jResponse.Add("photo", doctor.PhotoPath);
}
byte[] buf = Encoding.UTF8.GetBytes(jResponse.ToString());
context.Response.OutputStream.Write(buf, 0, buf.Length);
}
public UnifyApiResult Add(HospitalModel model)
{
if (model == null)
{
return(UnifyApiResult.Error("参数不能为空。"));
}
if (string.IsNullOrEmpty(model.HName))
{
return(UnifyApiResult.Error("医院名称不能为空。"));
}
HospitalDAL dal = new HospitalDAL();
if (dal.GetData(model.HName) != null)
{
return(UnifyApiResult.Error("医院名称不允许重复。"));
}
model.ModifyDate = DateTime.Now;
dynamic result = dal.Insert(model);
return(UnifyApiResult.Sucess(result));
}
public Int32 SelectByCityIDSpecialityIDRecordCount(SqlString CityID, SqlString SpecialityID)
{
HospitalDAL dalHospital = new HospitalDAL();
return(dalHospital.SelectByCityIDSpecialityIDRecordCount(CityID, SpecialityID));
}
public DataTable SelectByCityIDSpecialityID(SqlString CityID, SqlString SpecialityID, SqlInt32 PageIndex, SqlInt32 PageSize)
{
HospitalDAL dalHospital = new HospitalDAL();
return(dalHospital.SelectByCityIDSpecialityID(CityID, SpecialityID, PageIndex, PageSize));
}
public HospitalENT SelectByPK(SqlInt32 HospitalID)
{
HospitalDAL dalHospital = new HospitalDAL();
return(dalHospital.SelectByPK(HospitalID));
}
public HospitalBAL(string connectionString)
{
dal = new HospitalDAL(connectionString);
}
public void ProcessRequest(HttpContext context)
{
//通过医院的名称获得医生列表
StreamReader reader = new StreamReader(context.Request.InputStream, Encoding.UTF8);
string requestStr = reader.ReadToEnd();
//接收到的医院列表
JObject jObj = JObject.Parse(requestStr);
string hospitalName = jObj["name"].ToString();
string locStr = jObj["citycode"].ToString();
long hospital_id;
JObject jObjResult = new JObject();
JArray jArr = new JArray();
//先获得医院的主键id
if (HospitalDAL.Find(hospitalName, LocationDAL.GetCityId(locStr), out hospital_id))
{
//获得医生列表
DoctorModel[] doctors = DoctorDAL.GetByHospitalId(hospital_id);
foreach (var doctor in doctors)
{
JObject jObjDoc = new JObject();
jObjDoc.Add("name", doctor.RealName);
jObjDoc.Add("id", doctor.Name);
jObjDoc.Add("hospital", hospitalName);
jArr.Add(jObjDoc);
}
}
//int count = int.Parse(jObj["count"].ToString());
//JArray jArrHospitals = JArray.Parse(jObj["content"].ToString());
//JObject jObjResult = new JObject();
//JArray jArr = new JArray();
//for (int i = 0; i < count; i++)
//{
// string hospitalName = jArrHospitals[i]["name"].ToString();
// //这里传过来的locStr是类似于“四川省_成都市_青羊区”的字符串
// string locStr = jArrHospitals[i]["citycode"].ToString();
// long hospital_id;
// //先获得医院的主键id
// if (HospitalDAL.Find(hospitalName, LocationDAL.GetCityId(locStr), out hospital_id))
// {
// //获得医生列表
// DoctorModel[] doctors = DoctorDAL.GetByHospitalId(hospital_id);
// foreach (var doctor in doctors)
// {
// JObject jObjDoc = new JObject();
// jObjDoc.Add("name", doctor.RealName);
// jObjDoc.Add("id", doctor.Name);
// jObjDoc.Add("hospital", hospitalName);
// jArr.Add(jObjDoc);
// }
// }
//}
jObjResult.Add("count", jArr.Count);
jObjResult.Add("content", jArr);
byte[] buf = Encoding.UTF8.GetBytes(jObjResult.ToString());
context.Response.OutputStream.Write(buf, 0, buf.Length);
}
public HospitalServices(IMapper mapper)
{
_HospitalDAL = new HospitalDAL(mapper);
_mapper = mapper;
}
public DataTable SelectAll()
{
HospitalDAL dalHospital = new HospitalDAL();
return(dalHospital.SelectAll());
}
public HospitalBusinessLayer()
{
dataAccessLayer = new HospitalDAL();
}
public HospitalBL(HospitalDAL hospitalDAL)
{
this.hospitalDAL = hospitalDAL;
}
