/// <summary>
/// 根据管理机构（Institutions）的主键“机构编号（Id）”从数据库中获取管理机构（Institutions）的实例。
/// 成功从数据库中取得记录返回新管理机构（Institutions）的实例“，没有取到记录返回null值。
/// </summary>
/// <param name="id">管理机构（Institutions）的主键“机构编号（Id）”</param>
public override Institutions GetDataById(int id)
{
Institutions institutions = null;
string sqlText = "SELECT \"Id\",\"Name\",\"IType\",\"IAddress\",\"Phone\",\"Head\",\"SuperiorDepartments\",\"Remarks\" "
+ "FROM \"Institutions\" "
+ "WHERE \"Id\"=:Id";
OracleParameter[] parameters =
{
new OracleParameter(":Id", OracleType.Int32, 4)
{
Value = id
}
};
OracleDataReader oracleDataReader = SFL.OracleHelper.ExecuteReader(sqlText, parameters);
if (oracleDataReader.Read())
{
institutions = new Institutions();
ReadInstitutionsAllData(oracleDataReader, institutions);
}
oracleDataReader.Close();
return(institutions);
}
/// <summary>
/// 根据管理机构（Institutions）的主键“机构编号（Id）”从数据库中获取管理机构（Institutions）的实例。
/// 成功从数据库中取得记录返回新管理机构（Institutions）的实例“，没有取到记录返回null值。
/// </summary>
/// <param name="id">管理机构（Institutions）的主键“机构编号（Id）”</param>
public override Institutions GetDataById(int id)
{
Institutions institutions = null;
string sqlText = "SELECT [Id],[Name],[IType],[IAddress],[Phone],[Head],[SuperiorDepartments],[Remarks] "
+ "FROM [Institutions] "
+ "WHERE [Id]=@Id";
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
{
Value = id
}
};
SqlDataReader sqlDataReader = SFL.SqlHelper.ExecuteReader(sqlText, parameters);
if (sqlDataReader.Read())
{
institutions = new Institutions();
ReadInstitutionsAllData(sqlDataReader, institutions);
}
sqlDataReader.Close();
return(institutions);
}
}//end page_load
protected void ShowInstitutionSelect(int patientId)
{
groupMessage.Text = "";
PatientInstitutionDa da = new PatientInstitutionDa();
//get users existing insts
DataTable dt = da.GetPatientInstitutionsByPatientId(patientId);
rptInstitutions.DataSource = dt.DefaultView;
rptInstitutions.DataBind();
if (dt.Rows.Count == 0)
{
groupMessage.Text = "No Institutions Assigned. This patient will only be accessible in the All Dataset";
}
//get groups
InstitutionDa i = new InstitutionDa();
DataTable iDt = i.GetInstitutions();
Institutions.DataSource = iDt.DefaultView;
Institutions.DataValueField = "InstitutionId";
Institutions.DataTextField = "Institution";
Institutions.DataBind();
Institutions.Items.Insert(0, new ListItem(""));
SelectInstitutionTable.Visible = true;
}
/// <summary>
/// 从数据库中读取并返回所有管理机构（Institutions）List列表。
/// </summary>
public override List <Institutions> GetAllList()
{
string sqlText = "SELECT [Id],[Name],[IType],[IAddress],[Phone],[Head],[SuperiorDepartments],[Remarks] "
+ "FROM [Institutions]";
List <Institutions> list = new List <Institutions>();
SqlDataReader sqlDataReader = SFL.SqlHelper.ExecuteReader(sqlText, null);
while (sqlDataReader.Read())
{
Institutions institutions = new Institutions();
ReadInstitutionsAllData(sqlDataReader, institutions);
list.Add(institutions);
}
sqlDataReader.Close();
return(list);
}
/// <summary>
/// 从数据库中读取并返回所有管理机构（Institutions）List列表。
/// </summary>
public override List <Institutions> GetAllList()
{
string sqlText = "SELECT \"Id\",\"Name\",\"IType\",\"IAddress\",\"Phone\",\"Head\",\"SuperiorDepartments\",\"Remarks\" "
+ "FROM \"Institutions\"";
List <Institutions> list = new List <Institutions>();
OracleDataReader oracleDataReader = SFL.OracleHelper.ExecuteReader(sqlText, null);
while (oracleDataReader.Read())
{
Institutions institutions = new Institutions();
ReadInstitutionsAllData(oracleDataReader, institutions);
list.Add(institutions);
}
oracleDataReader.Close();
return(list);
}
public ActionResult Index()
{
string _banks = GetPlaidBanks();
List <Institution> banks = Institutions.FromJson(_banks).PurpleInstitutions;
List <Bank> Banks = new List <Bank>();
banks.ForEach(b => Banks.Add(new Bank {
BankName = b.Name
}));
//string _logoBank = GetPlaidBank();
//LogoBank logoBank = LogoBank.FromJson(_logoBank);
BanksViewModel vm = new BanksViewModel {
BankNames = Banks
};
return(View(vm));
}
/// <summary>
/// 将管理机构（Institutions）数据，根据主键“机构编号（Id）”采用UPDATE操作更新到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="institutions">管理机构（Institutions）实例对象</param>
public override int Update(Institutions institutions)
{
string sqlText = "UPDATE \"Institutions\" SET "
+ "\"Name\"=:Name,\"IType\"=:IType,\"IAddress\"=:IAddress,\"Phone\"=:Phone,\"Head\"=:Head,\"SuperiorDepartments\"=:SuperiorDepartments,"
+ "\"Remarks\"=:Remarks "
+ "WHERE \"Id\"=:Id";
OracleParameter[] parameters =
{
new OracleParameter(":Name", OracleType.NVarChar, 50)
{
Value = institutions.Name
},
new OracleParameter(":IType", OracleType.NVarChar, 50)
{
Value = institutions.IType
},
new OracleParameter(":IAddress", OracleType.NVarChar, 50)
{
Value = institutions.IAddress
},
new OracleParameter(":Phone", OracleType.NVarChar, 50)
{
Value = institutions.Phone
},
new OracleParameter(":Head", OracleType.NVarChar, 50)
{
Value = institutions.Head
},
new OracleParameter(":SuperiorDepartments", OracleType.Int32, 4)
{
Value = institutions.SuperiorDepartments
},
new OracleParameter(":Remarks", OracleType.NVarChar, 50)
{
Value = institutions.Remarks
},
new OracleParameter(":Id", OracleType.Int32, 4)
{
Value = institutions.Id
}
};
return(SFL.OracleHelper.ExecuteNonQuery(sqlText, parameters));
}
/// <summary>
/// 将管理机构（Institutions）数据，根据主键“机构编号（Id）”采用UPDATE操作更新到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="institutions">管理机构（Institutions）实例对象</param>
public override int Update(Institutions institutions)
{
string sqlText = "UPDATE [Institutions] SET "
+ "[Name]=@Name,[IType]=@IType,[IAddress]=@IAddress,[Phone]=@Phone,[Head]=@Head,[SuperiorDepartments]=@SuperiorDepartments,"
+ "[Remarks]=@Remarks "
+ "WHERE [Id]=@Id";
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 50)
{
Value = institutions.Name
},
new SqlParameter("@IType", SqlDbType.NVarChar, 50)
{
Value = institutions.IType
},
new SqlParameter("@IAddress", SqlDbType.NVarChar, 50)
{
Value = institutions.IAddress
},
new SqlParameter("@Phone", SqlDbType.NVarChar, 50)
{
Value = institutions.Phone
},
new SqlParameter("@Head", SqlDbType.NVarChar, 50)
{
Value = institutions.Head
},
new SqlParameter("@SuperiorDepartments", SqlDbType.Int, 4)
{
Value = institutions.SuperiorDepartments
},
new SqlParameter("@Remarks", SqlDbType.NVarChar, 50)
{
Value = institutions.Remarks
},
new SqlParameter("@Id", SqlDbType.Int, 4)
{
Value = institutions.Id
}
};
return(SFL.SqlHelper.ExecuteNonQuery(sqlText, parameters));
}
/// <summary>
/// 对管理机构（Institutions）实例对象，进行数据有效性检查。
/// </summary>
/// <param name="institutions">管理机构（Institutions）实例对象</param>
public static void CheckValid(Institutions institutions)
{
#region 检查各属性是否符合空值约束
if (DataValid.IsNull(institutions.Name))
{
throw new CustomException("“机构名称”不能为空，请您确认输入是否正确。");
}
#endregion
#region 检查字符串是否超出规定长度
if (DataValid.IsOutLength(institutions.Name, 50))
{
throw new CustomException("“机构名称”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(institutions.IType, 50))
{
throw new CustomException("“机构类型”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(institutions.IAddress, 50))
{
throw new CustomException("“机构地址”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(institutions.Phone, 50))
{
throw new CustomException("“联系电话”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(institutions.Head, 50))
{
throw new CustomException("“负责人”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
if (DataValid.IsOutLength(institutions.Remarks, 50))
{
throw new CustomException("“备注”长度不能超过 50 个汉字或字符，请您确认输入是否正确。");
}
#endregion
}
/// <summary>
/// 从DataReader中读取数据，并为Institutions对象的所有属性赋值。该方法主要由该类的子类调用。
/// </summary>
/// <param name="sqlDataReader">IDataReader</param>
/// <param name="institutions">管理机构（Institutions）实例对象</param>
protected void ReadInstitutionsAllData(IDataReader dataReader, Institutions institutions)
{
// 机构编号
if (dataReader["Id"] != DBNull.Value)
{
institutions.Id = Convert.ToInt32(dataReader["Id"]);
}
// 机构名称
if (dataReader["Name"] != DBNull.Value)
{
institutions.Name = Convert.ToString(dataReader["Name"]);
}
// 机构类型
if (dataReader["IType"] != DBNull.Value)
{
institutions.IType = Convert.ToString(dataReader["IType"]);
}
// 机构地址
if (dataReader["IAddress"] != DBNull.Value)
{
institutions.IAddress = Convert.ToString(dataReader["IAddress"]);
}
// 联系电话
if (dataReader["Phone"] != DBNull.Value)
{
institutions.Phone = Convert.ToString(dataReader["Phone"]);
}
// 负责人
if (dataReader["Head"] != DBNull.Value)
{
institutions.Head = Convert.ToString(dataReader["Head"]);
}
// 上级部门
if (dataReader["SuperiorDepartments"] != DBNull.Value)
{
institutions.SuperiorDepartments = Convert.ToInt32(dataReader["SuperiorDepartments"]);
}
// 备注
if (dataReader["Remarks"] != DBNull.Value)
{
institutions.Remarks = Convert.ToString(dataReader["Remarks"]);
}
}
//﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉
// 此区域的代码为多层框架式代码，实现了父类中定义的抽象方法。请不要直接修改该区域中的任何代码，
// 或在该区域中添加任何自定义代码，当该类发生变更时，您可以随时使用多层框架式代码覆盖其中的代码。
//﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍
/// <summary>
/// 将管理机构（Institutions）数据，采用INSERT操作插入到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="institutions">管理机构（Institutions）实例对象</param>
public override int Insert(Institutions institutions)
{
string sqlText = "INSERT INTO \"Institutions\""
+ "(\"Name\",\"IType\",\"IAddress\",\"Phone\",\"Head\",\"SuperiorDepartments\",\"Remarks\")"
+ "VALUES"
+ "(:Name,:IType,:IAddress,:Phone,:Head,:SuperiorDepartments,:Remarks)";
OracleParameter[] parameters =
{
new OracleParameter(":Name", OracleType.NVarChar, 50)
{
Value = institutions.Name
},
new OracleParameter(":IType", OracleType.NVarChar, 50)
{
Value = institutions.IType
},
new OracleParameter(":IAddress", OracleType.NVarChar, 50)
{
Value = institutions.IAddress
},
new OracleParameter(":Phone", OracleType.NVarChar, 50)
{
Value = institutions.Phone
},
new OracleParameter(":Head", OracleType.NVarChar, 50)
{
Value = institutions.Head
},
new OracleParameter(":SuperiorDepartments", OracleType.Int32, 4)
{
Value = institutions.SuperiorDepartments
},
new OracleParameter(":Remarks", OracleType.NVarChar, 50)
{
Value = institutions.Remarks
}
};
return(SFL.OracleHelper.ExecuteNonQuery(sqlText, parameters));
}
//﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉
// 此区域的代码为多层框架式代码，实现了父类中定义的抽象方法。请不要直接修改该区域中的任何代码，
// 或在该区域中添加任何自定义代码，当该类发生变更时，您可以随时使用多层框架式代码覆盖其中的代码。
//﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍
/// <summary>
/// 将管理机构（Institutions）数据，采用INSERT操作插入到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="institutions">管理机构（Institutions）实例对象</param>
public override int Insert(Institutions institutions)
{
string sqlText = "INSERT INTO [Institutions]"
+ "([Name],[IType],[IAddress],[Phone],[Head],[SuperiorDepartments],[Remarks])"
+ "VALUES"
+ "(@Name,@IType,@IAddress,@Phone,@Head,@SuperiorDepartments,@Remarks)";
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 50)
{
Value = institutions.Name
},
new SqlParameter("@IType", SqlDbType.NVarChar, 50)
{
Value = institutions.IType
},
new SqlParameter("@IAddress", SqlDbType.NVarChar, 50)
{
Value = institutions.IAddress
},
new SqlParameter("@Phone", SqlDbType.NVarChar, 50)
{
Value = institutions.Phone
},
new SqlParameter("@Head", SqlDbType.NVarChar, 50)
{
Value = institutions.Head
},
new SqlParameter("@SuperiorDepartments", SqlDbType.Int, 4)
{
Value = institutions.SuperiorDepartments
},
new SqlParameter("@Remarks", SqlDbType.NVarChar, 50)
{
Value = institutions.Remarks
}
};
return(SFL.SqlHelper.ExecuteNonQuery(sqlText, parameters));
}
/// <summary>
/// 根据每页记录数及所要获取的页数，从数据库中读取并返回经过分页后的管理机构（Institutions）的列表及分页信息。
/// 该方法所获取的管理机构（Institutions）列表仅用于在数据控件中显示，该方法只为对象中需要显示的属性进行赋值。
/// </summary>
public override PageData GetPageList(int pageSize, int curPage)
{
string sqlText = "SELECT \"Id\",\"Name\",\"IType\",\"IAddress\",\"Phone\",\"Head\",\"SuperiorDepartments\",\"Remarks\" "
+ "FROM \"Institutions\"";
List <Institutions> list = new List <Institutions>();
OracleDataReader oracleDataReader = SFL.OracleHelper.ExecuteReader(sqlText, null);
PageData pageData = new PageData();
pageData.PageSize = pageSize;
pageData.CurPage = curPage;
pageData.RecordCount = 0;
pageData.PageCount = 1;
int first = (curPage - 1) * pageSize + 1;
int last = curPage * pageSize;
while (oracleDataReader.Read())
{
pageData.RecordCount++;
if (pageData.RecordCount >= first && last >= pageData.RecordCount)
{
Institutions institutions = new Institutions();
ReadInstitutionsPageData(oracleDataReader, institutions);
list.Add(institutions);
}
}
oracleDataReader.Close();
if (pageData.RecordCount > 0)
{
pageData.PageCount = Convert.ToInt32(Math.Ceiling((double)pageData.RecordCount / (double)pageSize));
}
pageData.PageList = list;
return(pageData);
}
/// <summary>
/// 根据每页记录数及所要获取的页数，从数据库中读取并返回经过分页后的管理机构（Institutions）的列表及分页信息。
/// 该方法所获取的管理机构（Institutions）列表仅用于在数据控件中显示，该方法只为对象中需要显示的属性进行赋值。
/// </summary>
public override PageData GetPageList(int pageSize, int curPage)
{
string sqlText = "SELECT [Id],[Name],[IType],[IAddress],[Phone],[Head],[SuperiorDepartments],[Remarks] "
+ "FROM [Institutions]";
List <Institutions> list = new List <Institutions>();
SqlDataReader sqlDataReader = SFL.SqlHelper.ExecuteReader(sqlText, null);
PageData pageData = new PageData();
pageData.PageSize = pageSize;
pageData.CurPage = curPage;
pageData.RecordCount = 0;
pageData.PageCount = 1;
int first = (curPage - 1) * pageSize + 1;
int last = curPage * pageSize;
while (sqlDataReader.Read())
{
pageData.RecordCount++;
if (pageData.RecordCount >= first && last >= pageData.RecordCount)
{
Institutions institutions = new Institutions();
ReadInstitutionsPageData(sqlDataReader, institutions);
list.Add(institutions);
}
}
sqlDataReader.Close();
if (pageData.RecordCount > 0)
{
pageData.PageCount = Convert.ToInt32(Math.Ceiling((double)pageData.RecordCount / (double)pageSize));
}
pageData.PageList = list;
return(pageData);
}
/// <summary>
/// 从DataReader中读取数据，并为Resident对象的所有属性赋值。该方法主要由该类的子类调用。
/// </summary>
/// <param name="sqlDataReader">IDataReader</param>
/// <param name="resident">居民（Resident）实例对象</param>
protected void ReadResidentAllData(IDataReader dataReader, Resident resident)
{
// 自动编号
if (dataReader["Id"] != DBNull.Value)
{
resident.Id = Convert.ToInt32(dataReader["Id"]);
}
// 居民号
if (dataReader["ResidentId"] != DBNull.Value)
{
resident.ResidentId = Convert.ToString(dataReader["ResidentId"]);
}
// 姓名
if (dataReader["Name"] != DBNull.Value)
{
resident.Name = Convert.ToString(dataReader["Name"]);
}
// 身份证号
if (dataReader["IdNumber"] != DBNull.Value)
{
resident.IdNumber = Convert.ToString(dataReader["IdNumber"]);
}
// 性别
if (dataReader["Sex"] != DBNull.Value)
{
resident.Sex = Convert.ToInt32(dataReader["Sex"]);
}
// 联系电话
if (dataReader["Phone"] != DBNull.Value)
{
resident.Phone = Convert.ToString(dataReader["Phone"]);
}
// 出生日期
if (dataReader["DateOfBirth"] != DBNull.Value)
{
resident.DateOfBirth = Convert.ToDateTime(dataReader["DateOfBirth"]);
}
// 民族
if (dataReader["Nation"] != DBNull.Value)
{
resident.Nation = Convert.ToString(dataReader["Nation"]);
}
// 联系人姓名
if (dataReader["ContactName"] != DBNull.Value)
{
resident.ContactName = Convert.ToString(dataReader["ContactName"]);
}
// 联系人电话
if (dataReader["ContactPhone"] != DBNull.Value)
{
resident.ContactPhone = Convert.ToString(dataReader["ContactPhone"]);
}
// 文化程度
if (dataReader["Education"] != DBNull.Value)
{
resident.Education = Convert.ToInt32(dataReader["Education"]);
}
// 血型
if (dataReader["BloodType"] != DBNull.Value)
{
resident.BloodType = Convert.ToInt32(dataReader["BloodType"]);
}
// 职业
if (dataReader["Professional"] != DBNull.Value)
{
resident.Professional = Convert.ToString(dataReader["Professional"]);
}
// 工作单位
if (dataReader["WorkUnits"] != DBNull.Value)
{
resident.WorkUnits = Convert.ToString(dataReader["WorkUnits"]);
}
// 医疗费用支付方式
if (dataReader["Payment"] != DBNull.Value)
{
resident.Payment = Convert.ToInt32(dataReader["Payment"]);
}
// 家庭档案号
if (dataReader["FamilyId"] != DBNull.Value)
{
Family tmpFamily = FamilyDAL.Instance.GetDataById(Convert.ToInt32(dataReader["FamilyId"]));
if (tmpFamily != null)
{
resident.FamilyId = tmpFamily;
}
}
// 婚姻状况
if (dataReader["MaritalStatus"] != DBNull.Value)
{
resident.MaritalStatus = Convert.ToInt32(dataReader["MaritalStatus"]);
}
// 子女数
if (dataReader["Children"] != DBNull.Value)
{
resident.Children = Convert.ToInt32(dataReader["Children"]);
}
// 父亲姓名
if (dataReader["FathersName"] != DBNull.Value)
{
resident.FathersName = Convert.ToString(dataReader["FathersName"]);
}
// 母亲姓名
if (dataReader["MotherName"] != DBNull.Value)
{
resident.MotherName = Convert.ToString(dataReader["MotherName"]);
}
// 监护人姓名
if (dataReader["GuardiansName"] != DBNull.Value)
{
resident.GuardiansName = Convert.ToString(dataReader["GuardiansName"]);
}
// 监护人电话
if (dataReader["GuardianPhone"] != DBNull.Value)
{
resident.GuardianPhone = Convert.ToString(dataReader["GuardianPhone"]);
}
// 人群类型
if (dataReader["CrowdType"] != DBNull.Value)
{
resident.CrowdType = Convert.ToInt32(dataReader["CrowdType"]);
}
// 居住类型
if (dataReader["ResidentialType"] != DBNull.Value)
{
resident.ResidentialType = Convert.ToInt32(dataReader["ResidentialType"]);
}
// 常住类型
if (dataReader["PermanentType"] != DBNull.Value)
{
resident.PermanentType = Convert.ToInt32(dataReader["PermanentType"]);
}
// 户籍所在地
if (dataReader["Registered"] != DBNull.Value)
{
resident.Registered = Convert.ToString(dataReader["Registered"]);
}
// 户籍地址
if (dataReader["RegisteredAddress"] != DBNull.Value)
{
resident.RegisteredAddress = Convert.ToString(dataReader["RegisteredAddress"]);
}
// 现居住所在地
if (dataReader["Live"] != DBNull.Value)
{
resident.Live = Convert.ToString(dataReader["Live"]);
}
// 现居住地址
if (dataReader["LiveAddress"] != DBNull.Value)
{
resident.LiveAddress = Convert.ToString(dataReader["LiveAddress"]);
}
// 建档机构
if (dataReader["InputtingInstitutions"] != DBNull.Value)
{
Institutions tmpInstitutions = InstitutionsDAL.Instance.GetDataById(Convert.ToInt32(dataReader["InputtingInstitutions"]));
if (tmpInstitutions != null)
{
resident.InputtingInstitutions = tmpInstitutions;
}
}
// 建档人
if (dataReader["InputtingPerson"] != DBNull.Value)
{
resident.InputtingPerson = Convert.ToString(dataReader["InputtingPerson"]);
}
// 建档时间
if (dataReader["InputtingTime"] != DBNull.Value)
{
resident.InputtingTime = Convert.ToDateTime(dataReader["InputtingTime"]);
}
// 责任医生
if (dataReader["ResponsibleDoctor"] != DBNull.Value)
{
resident.ResponsibleDoctor = Convert.ToString(dataReader["ResponsibleDoctor"]);
}
// 管理状态
if (dataReader["ManagementStatus"] != DBNull.Value)
{
resident.ManagementStatus = Convert.ToInt32(dataReader["ManagementStatus"]);
}
// 启用时间
if (dataReader["EnableTime"] != DBNull.Value)
{
resident.EnableTime = Convert.ToDateTime(dataReader["EnableTime"]);
}
// 是否社会关注人群
if (dataReader["FocusOn"] != DBNull.Value)
{
resident.FocusOn = Convert.ToBoolean(dataReader["FocusOn"]);
}
// RH阴性
if (dataReader["RHNegative"] != DBNull.Value)
{
resident.RHNegative = Convert.ToBoolean(dataReader["RHNegative"]);
}
// 备注
if (dataReader["Remarks"] != DBNull.Value)
{
resident.Remarks = Convert.ToString(dataReader["Remarks"]);
}
}
/// <summary>
/// 从DataReader中读取数据，并为Resident对象需要进行显示的属性赋值。该方法主要由该类的子类调用。
/// </summary>
/// <param name="sqlDataReader">IDataReader</param>
/// <param name="resident">居民（Resident）实例对象</param>
protected void ReadResidentPageData(IDataReader dataReader, Resident resident)
{
// 自动编号
if (dataReader["Id"] != DBNull.Value)
{
resident.Id = Convert.ToInt32(dataReader["Id"]);
}
// 居民号
if (dataReader["ResidentId"] != DBNull.Value)
{
resident.ResidentId = Convert.ToString(dataReader["ResidentId"]);
}
// 姓名
if (dataReader["Name"] != DBNull.Value)
{
resident.Name = Convert.ToString(dataReader["Name"]);
}
// 身份证号
if (dataReader["IdNumber"] != DBNull.Value)
{
resident.IdNumber = Convert.ToString(dataReader["IdNumber"]);
}
// 性别
if (dataReader["Sex"] != DBNull.Value)
{
resident.Sex = Convert.ToInt32(dataReader["Sex"]);
}
// 家庭档案号
if (dataReader["FamilyId"] != DBNull.Value)
{
Family tmpFamily = FamilyDAL.Instance.GetDataById(Convert.ToInt32(dataReader["FamilyId"]));
if (tmpFamily != null)
{
resident.FamilyId = tmpFamily;
}
}
// 建档机构
if (dataReader["InputtingInstitutions"] != DBNull.Value)
{
Institutions tmpInstitutions = InstitutionsDAL.Instance.GetDataById(Convert.ToInt32(dataReader["InputtingInstitutions"]));
if (tmpInstitutions != null)
{
resident.InputtingInstitutions = tmpInstitutions;
}
}
// 建档人
if (dataReader["InputtingPerson"] != DBNull.Value)
{
resident.InputtingPerson = Convert.ToString(dataReader["InputtingPerson"]);
}
// 建档时间
if (dataReader["InputtingTime"] != DBNull.Value)
{
resident.InputtingTime = Convert.ToDateTime(dataReader["InputtingTime"]);
}
// 责任医生
if (dataReader["ResponsibleDoctor"] != DBNull.Value)
{
resident.ResponsibleDoctor = Convert.ToString(dataReader["ResponsibleDoctor"]);
}
// 管理状态
if (dataReader["ManagementStatus"] != DBNull.Value)
{
resident.ManagementStatus = Convert.ToInt32(dataReader["ManagementStatus"]);
}
// 启用时间
if (dataReader["EnableTime"] != DBNull.Value)
{
resident.EnableTime = Convert.ToDateTime(dataReader["EnableTime"]);
}
}
/// <summary>
/// String representation of this author
/// </summary>
public override string ToString()
{
return(String.Format("Person: {0}\nInstitions: {1}\nRoles: {2}\nSpecialties{3}",
Person == null ? "none" : Person.ToString(),
Institutions == null || Institutions.Count == 0 ? "none" : Institutions.Skip(1).Aggregate(Institutions.First().ToString(), (a, i) => a + ", " + i.ToString()),
String.Join(", ", Roles == null || Roles.Count == 0 ? new string[] { "none" } : Roles.ToArray()),
String.Join(", ", Specialities == null || Specialities.Count == 0 ? new string[] { "none" }: Specialities.ToArray())));
}
/// <summary>
/// Tests equality between this instance and another
/// </summary>
public bool Equals(Author other)
{
if (other == null)
{
return(false);
}
bool personEqual = Person.Equals(other.Person);
bool institutionsEqual = (Institutions.Count == other.Institutions.Count) && Institutions.All(i => other.Institutions.Contains(i));
bool rolesEqual = (Roles.Count == other.Roles.Count) && Roles.All(r => other.Roles.Contains(r));
bool specialitiesEqual = (Specialities.Count == other.Specialities.Count) && Specialities.All(s => other.Specialities.Contains(s));
return(personEqual && institutionsEqual && rolesEqual && specialitiesEqual);
}
public void Add(Institutions i)
{
_connection.Insert(i);
}
public void Update(Institutions i)
{
_connection.Update(i);
}
/// <summary>
/// 将管理机构（Institutions）数据，采用INSERT操作插入到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="institutions">管理机构（Institutions）实例对象</param>
public static int Insert(Institutions institutions)
{
CheckValid(institutions);
return(DataAccess.Insert(institutions));
}
//﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉﹉
// 公共数据访问类抽象方法定义，在SqlServer/Oracle/OleDb子类中实现具体方法。
//﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍﹍
/// <summary>
/// 将管理机构（Institutions）数据，采用INSERT操作插入到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="institutions">管理机构（Institutions）实例对象</param>
public abstract int Insert(Institutions institutions);
/// <summary> /// 将管理机构（Institutions）数据，根据主键“机构编号（Id）”采用UPDATE操作更新到数据库中，并返回受影响的行数。 /// </summary> /// <param name="institutions">管理机构（Institutions）实例对象</param> public abstract int Update(Institutions institutions);
/// <summary>
/// 将管理机构（Institutions）数据，根据主键“机构编号（Id）”采用UPDATE操作更新到数据库中，并返回受影响的行数。
/// </summary>
/// <param name="institutions">管理机构（Institutions）实例对象</param>
public static int Update(Institutions institutions)
{
CheckValid(institutions);
return(DataAccess.Update(institutions));
}
public static Institutions GetInstitutions(object[] args)
{
try
{
while (_retrievingInsitutions)
{
System.Threading.Thread.Sleep(500);
}
_retrievingInsitutions = true;
String cacheFilePath = args[0].ToString();
Cache cache = (Cache)args[1];
String userId = (String)args[2];
if (cache["Insitutions"] == null)
{
string encryptionKey = System.Configuration.ConfigurationManager.AppSettings["FileEncryptionKey"];
Institutions financialInstitutions = null;
System.Xml.Serialization.XmlSerializer serializer = new System.Xml.Serialization.XmlSerializer(typeof(Institutions));
if (System.IO.File.Exists(cacheFilePath) && (new FileInfo(cacheFilePath)).Length > 0)
{
try
{
String financialInstitutionList = Encryption.Decrypt(System.IO.File.ReadAllText(cacheFilePath), encryptionKey);
StringReader text = new StringReader(financialInstitutionList);
System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create(text);
financialInstitutions = (Institutions)serializer.Deserialize(xmlReader);
}
catch
{
}
}
if (financialInstitutions == null)
{
financialInstitutions = Services.AggCatService.GetService(cache, userId).GetInstitutions();
try
{
StringBuilder financialInstitutionList = new StringBuilder();
System.Xml.XmlWriter xmlWriter = System.Xml.XmlWriter.Create(financialInstitutionList);
serializer.Serialize(xmlWriter, financialInstitutions);
xmlWriter.Flush();
xmlWriter.Close();
System.IO.File.WriteAllText(cacheFilePath, Encryption.Encrypt(financialInstitutionList.ToString(), encryptionKey));
}
catch
{
}
}
cache.Add("Insitutions", financialInstitutions,
null,
Cache.NoAbsoluteExpiration, Cache.NoSlidingExpiration, CacheItemPriority.High, null);
InstitutionsRetrieved = true;
}
return((Institutions)cache["Insitutions"]);
}
catch (Exception)
{
throw;
}
finally
{
_retrievingInsitutions = false;
}
}
/// <summary>
/// 从DataReader中读取数据，并为Family对象的所有属性赋值。该方法主要由该类的子类调用。
/// </summary>
/// <param name="sqlDataReader">IDataReader</param>
/// <param name="family">家庭（Family）实例对象</param>
protected void ReadFamilyAllData(IDataReader dataReader, Family family)
{
// 家庭档案号
if (dataReader["Id"] != DBNull.Value)
{
family.Id = Convert.ToInt32(dataReader["Id"]);
}
// 家庭名称
if (dataReader["Name"] != DBNull.Value)
{
family.Name = Convert.ToString(dataReader["Name"]);
}
// 户主
if (dataReader["Owner"] != DBNull.Value)
{
family.Owner = Convert.ToString(dataReader["Owner"]);
}
// 家庭类型
if (dataReader["FamilyType"] != DBNull.Value)
{
family.FamilyType = Convert.ToInt32(dataReader["FamilyType"]);
}
// 住房类型
if (dataReader["HousingTypes"] != DBNull.Value)
{
family.HousingTypes = Convert.ToInt32(dataReader["HousingTypes"]);
}
// 家庭总人数
if (dataReader["Total"] != DBNull.Value)
{
family.Total = Convert.ToInt32(dataReader["Total"]);
}
// 负责老人数
if (dataReader["Old"] != DBNull.Value)
{
family.Old = Convert.ToInt32(dataReader["Old"]);
}
// 责任医生
if (dataReader["ResponsibleDoctor"] != DBNull.Value)
{
family.ResponsibleDoctor = Convert.ToString(dataReader["ResponsibleDoctor"]);
}
// 创建日期
if (dataReader["CreateDate"] != DBNull.Value)
{
family.CreateDate = Convert.ToDateTime(dataReader["CreateDate"]);
}
// 管理机构
if (dataReader["ManageInstitutionsId"] != DBNull.Value)
{
Institutions temp = InstitutionsDAL.Instance.GetDataById(Convert.ToInt32(dataReader["ManageInstitutionsId"]));
if (temp != null)
{
family.ManageInstitutions = temp;
}
}
// 备注
if (dataReader["Remark"] != DBNull.Value)
{
family.Remark = Convert.ToString(dataReader["Remark"]);
}
}
