public PatientMapModel(string p_connectionString)
{
string connStr = localConnectionString;
if (!string.IsNullOrEmpty(p_connectionString))
{
connStr = p_connectionString;
}
PatientTableMap = TableMapModel.CreateEmptyPatientTableMap();
IDatabaseHelper db = DatabaseHelper.Open(DataBaseSoft.TransDatabaseSoft(DatabaseSoft.SQLServer, false), connStr);
string sql = "select *,'' as Value from kr_check_type where DeleteFlag = 0";
DataTable dt = db.ExecuteQuery(sql);
CheckTypeMapList = new CheckTypeMapListModel(dt);
}
public static TableMapModel CreateEmptyPatientTableMap()
{
var model = new TableMapModel
{
new TableFieldMapModel
{
CanUserDelete = false,
DisplayName = "病案号",
IsWhere = true,
LocalField = "PatientID",
Type = "String"
},
new TableFieldMapModel
{
CanUserDelete = false,
DisplayName = "姓名",
IsWhere = false,
LocalField = "Name",
Type = "String"
},
new TableFieldMapModel
{
CanUserDelete = false,
DisplayName = "性别",
IsWhere = false,
LocalField = "Gender",
Type = "Int",
Comment = "0 - Male, 1 - Female"
},
new TableFieldMapModel
{
CanUserDelete = false,
DisplayName = "生日",
IsWhere = false,
LocalField = "BirthDay",
Type = "Date"
},
new TableFieldMapModel
{
CanUserDelete = false,
DisplayName = "年龄",
IsWhere = false,
LocalField = "Age",
Type = "Int"
},
new TableFieldMapModel
{
CanUserDelete = false,
DisplayName = "申请医生",
IsWhere = false,
LocalField = "RequestDoctor",
Type = "Int"
},
new TableFieldMapModel
{
CanUserDelete = false,
DisplayName = "申请科室",
IsWhere = false,
LocalField = "RequestDepot",
Type = "Int"
},
new TableFieldMapModel
{
CanUserDelete = false,
DisplayName = "申请时间",
IsWhere = false,
LocalField = "RequestDate",
Type = "Date"
},
new TableFieldMapModel
{
CanUserDelete = false,
DisplayName = "检查科室",
IsWhere = false,
LocalField = "ExamDepartment",
Type = "String"
},
new TableFieldMapModel
{
CanUserDelete = false,
DisplayName = "检查医师",
IsWhere = false,
LocalField = "ExamDoctor",
Type = "String"
},
new TableFieldMapModel
{
CanUserDelete = false,
DisplayName = "诊断医师",
IsWhere = false,
LocalField = "DiagnosticianDoctor",
Type = "String"
},
};
return(model);
}
