public HttpResponseMessage GetAllTreatment()
{
HttpResponseMessage response = new HttpResponseMessage();
string doc_id = HttpContext.Current.User.Identity.Name;
if (doc_id.Equals(""))
{
doc_id = "16687";
}
// 在数据库treatment表找到所有与当前医生doc_id相关的所有挂号记录
// treatment natural join takes using(treat_id)
// tekes.doc_id若为空 取出这条数据组成数组
// 设置takes表treat_id对应记录的doc_id为当前doc_id
try
{
ArrayList list = DoctorHelper.GetAllTreatment(doc_id);
JArray resArray = new JArray();
if (list.Count == 0)
{
resArray.Add(0);
}
else
{
resArray.Add("1");
string jsonRes = JsonObjectConverter.ObjectToJson(list);
var strObject = JsonConvert.DeserializeObject(jsonRes) as JArray;
for (int i = 0; i < strObject.Count; i++)
{
JObject tmpObj = JObject.Parse(strObject[i].ToString());
JObject obj = new JObject();
string patient_id = tmpObj.GetValue("patient_id").ToString();
string employee_id = tmpObj.GetValue("doc_id").ToString();
PatientInfo patientInfo = UserHelper.GetPatientInfo(patient_id);
EmployeeInfo employeeInfo = UserHelper.GetEmployeeInfo(employee_id);
string treatment_id = tmpObj.GetValue("treat_id").ToString();
string patient_name = patientInfo.name.ToString();
string clinic = tmpObj.GetValue("clinic").ToString();
string employee_name = employeeInfo.name.ToString();
string start_time = tmpObj.GetValue("start_time").ToString();
string take = tmpObj.GetValue("take").ToString();
obj.Add("treatment_id", treatment_id);
obj.Add("patient_name", patient_name);
obj.Add("clinic", clinic);
obj.Add("employee_name", employee_name);
obj.Add("start_time", start_time);
obj.Add("take", take);
resArray.Add(obj);
}
}
response.Content = new StringContent(JsonObjectConverter.ObjectToJson(resArray));
}
catch (Exception e)
{
response.Content = new StringContent(e.Message);
response.StatusCode = HttpStatusCode.BadRequest;
}
return(response);
}
public HttpResponseMessage WritePrescription(dynamic obj)
{
ArrayList medicine_id = new ArrayList();
ArrayList num = new ArrayList();
HttpResponseMessage response = new HttpResponseMessage();
try
{
string jsonRes = JsonObjectConverter.ObjectToJson(obj);
var strObject = JsonConvert.DeserializeObject(jsonRes) as JArray;
var treatment_id = strObject[0].ToString();
// 遍历strObject得到每一个药物
for (int i = 1; i < strObject.Count; i++)
{
JObject tmpObj = JObject.Parse(strObject[i].ToString());
var id = tmpObj["id"];
var number = tmpObj["number"];
medicine_id.Add(id);
num.Add(number);
}
string doc_id = "16656";
// TODO:
// doc_id随机分配一个而不是从Cookie来
ArrayList empList = UserHelper.GetAllEmployee();
ArrayList pharmacist = new ArrayList();
foreach (EmployeeInfo item in empList)
{
// 获取所有药剂师
if (item.post.Equals("Pharmacist"))
{
pharmacist.Add(item);
}
}
// 随机选择一个药剂师
Random rand = new Random();
if (pharmacist.Count > 0)
{
int index = rand.Next(0, pharmacist.Count - 1);
doc_id = ((EmployeeInfo)pharmacist[index]).employee_id;
}
// prescription表创建一条记录
// 设置pres_id treat_id doc_id从药剂师中随机挑选 time
// 其他空值
// prescribeb表创建一条记录
// 设置pres_id medicine_id num
DoctorHelper.WritePrescription(treatment_id, doc_id, medicine_id, num);
}
catch (Exception e)
{
response.Content = new StringContent(e.Message);
response.StatusCode = HttpStatusCode.BadRequest;
return(response);
}
response.Content = new StringContent("开方成功！");
return(response);
}
public HttpResponseMessage GetAllMedicine()
{
// 从medicine表获取所有的药品的数据
ArrayList list = DoctorHelper.GetAllMedicine();
HttpResponseMessage response = new HttpResponseMessage();
response.Content = new StringContent(JsonObjectConverter.ObjectToJson(list));
return(response);
}
public HttpResponseMessage WriteSurgey(string treatment_id, string surgey_name)
{
// surgery表插入数据
// 设置surg_id treat_id surgey_name start_time end_time pay
HttpResponseMessage response = new HttpResponseMessage();
if (!DoctorHelper.WriteSurgery(treatment_id, surgey_name))
{
response.StatusCode = HttpStatusCode.BadRequest;
response.Content = new StringContent("添加失败！");
}
return(response);
}
public HttpResponseMessage WriteHospitalization(string treatment_id)
{
// 一个住院病人只有一个护士 一个护士可以有多个住院病人
// hospitalization表增加
// 设置hos_id treat_id nurse_id随机生成，在employee表查找 bed_num需要唯一 in_time系统获取
// out_time空 pay随机生成
HttpResponseMessage response = new HttpResponseMessage();
try
{
DoctorHelper.WriteHospitalization(treatment_id);
}
catch (Exception e)
{
response.StatusCode = HttpStatusCode.BadRequest;
response.Content = new StringContent(e.Message);
}
return(response);
}
public HttpResponseMessage TakesRegistration(string treatment_id)
{
string doc_id = HttpContext.Current.User.Identity.Name;
HttpResponseMessage response = new HttpResponseMessage();
try
{
DoctorHelper.TakeTreat(doc_id, treatment_id);
}
catch (Exception e)
{
response.Content = new StringContent(e.Message);
response.StatusCode = HttpStatusCode.BadRequest;
return(response);
}
response.Content = new StringContent("接诊成功！医生:" + doc_id + " 病人：" + treatment_id);
// tekes表填充treatment_id对应的doc_id
response.StatusCode = HttpStatusCode.OK;
return(response);
}
public HttpResponseMessage WriteExamination(string treatment_id, string exam_type)
{
HttpResponseMessage response = new HttpResponseMessage();
string doc_id = HttpContext.Current.User.Identity.Name;
//doc_id = "16687";
try
{
switch (int.Parse(exam_type))
{
case 0:
case 1:
case 2:
if (!DoctorHelper.WriteExamination(treatment_id, doc_id, int.Parse(exam_type)))
{
response.StatusCode = HttpStatusCode.BadRequest;
response.Content = new StringContent("insert table failed");
}
break;
default:
response.Content = new StringContent("exam_type invalid");
response.StatusCode = HttpStatusCode.BadRequest;
break;
}
}
catch (Exception e)
{
response.Content = new StringContent(e.Message);
}
// 开了检查单子 没交费 没做检查
// examination表设置exam_Id, type, doc_id
// 其他留空
// exam表插入数据
// 把exam_id和treatment_id关联起来
return(response);
}
