//手术信息
public List <SurgeryDetailedInformation> GetSurgeryDetailedInformation(string oprationState, string searchType, string area, string operationType, string sDate, string eDate, string content)
{
string[] SurgeryCode = { "330301", "330303", "330401", "330526", "330401", "330506", "330701", "330625" };
string[] OperatingRoomCode = { "01", "01", "01", "04", "05", "03", "03", "01" };
string[] PateintName = { "林小莲", "吴冰冰", "李国光", "杨光", "金耀秋", "刘小媚", "林碎花", "李丽" };
string[] SurgeryName = { "剖宫产手术", "肠切除术", "皮肤清创术", "膀胱造瘘管置换术 ", "附睾囊肿切除术", "小清创缝合术", "皮脂囊肿切除术", "纤维瘤切除术" };
string[] SurgeryType = { "1", "1", "1", "1", "2", "2", "2", "2" };
string[] SurgeonDoctor = { "陈肖俊", "陈肖俊", "陈肖俊", "张宇", "张宇", "张宇", "张宇", "张宇" };
string[] Anesthesiologist = { "金建国", "金建国", "金建国", "金建国", "金建国", "陈思思", "陈思思", "陈思思" };
List <SurgeryDetailedInformation> list_model = new List <SurgeryDetailedInformation>();
Random random = new Random();
for (int i = 1; i < 8; i++)
{
SurgeryDetailedInformation model = new SurgeryDetailedInformation();
model.SurgeryCode = SurgeryCode[i];
model.OperatingRoomCode = OperatingRoomCode[i];
model.PateintName = PateintName[i];
model.SurgeryName = SurgeryName[i];
model.SurgeryType = SurgeryType[i];
model.SurgeonDoctor = SurgeonDoctor[i];
model.Anesthesiologist = Anesthesiologist[i];
model.SurgeryStartTime = DateTime.Now.AddHours(-i);
list_model.Add(model);
}
return(list_model);
}
public List <SurgeryDetailedInformation> GetSurgeryDetailedInformation(string oprationState, string searchType, string area, string operationType, string sDate, string eDate, string content)
{
List <SurgeryDetailedInformation> list_model = new List <SurgeryDetailedInformation>();
String command = GetCommandForSurgeryDetailedInformation(oprationState, searchType, area, operationType, sDate, eDate, content);
DbCommand queryCommand = db.GetSqlStringCommand(command);
using (IDataReader reader = db.ExecuteReader(queryCommand))
{
while (reader.Read())
{
SurgeryDetailedInformation model = new SurgeryDetailedInformation();
model.SurgeryCode = reader["SurgeryCode"] is DBNull ? "" : reader["SurgeryCode"].ToString();
model.OperatingRoomCode = reader["OperatingRoomCode"] is DBNull ? "" : reader["OperatingRoomCode"].ToString();
model.PateintName = reader["PateintName"] is DBNull ? "" : reader["PateintName"].ToString();
if (reader["SurgeryStartTime"] is DBNull)
{
model.SurgeryStartTime = null;
}
else
{
model.SurgeryStartTime = Convert.ToDateTime(reader["SurgeryStartTime"].ToString());
}
model.SurgeryType = reader["SurgeryType"] is DBNull ? "" : reader["SurgeryType"].ToString();
model.SurgeonDoctor = reader["SurgeonDoctor"] is DBNull ? "" : reader["SurgeonDoctor"].ToString();
model.Anesthesiologist = reader["Anesthesiologist"] is DBNull ? "" : reader["Anesthesiologist"].ToString();
model.SurgeryName = reader["SurgeryName"] is DBNull ? "" : reader["SurgeryName"].ToString();
list_model.Add(model);
}
}
return(list_model);
}