/// <summary>
/// 根据证件类型ID查询类型名称
/// </summary>
/// <param name="passPortType"></param>
/// <returns></returns>
public PassPortType SelectPassPortTypeByTypeId(PassPortType passPortType)
{
PassPortType passPortType1 = new PassPortType();
passPortType1 = base.Change <PassPortType>().GetSingle(a => a.PassportId == passPortType.PassportId && a.delete_mk != 1);
return(passPortType1);
}
/// <summary>
/// 更新证件类型
/// </summary>
/// <param name="portType"></param>
/// <returns></returns>
public bool UpdatePassPortType(PassPortType portType)
{
return(base.Change <PassPortType>().Update(a => new PassPortType()
{
PassportName = portType.PassportName,
datachg_usr = AdminInfo.Account,
datachg_date = DateTime.Now
}, a => a.PassportId == portType.PassportId));
}
/// <summary>
/// 查询所有证件类型
/// </summary>
/// <returns></returns>
public static List <PassPortType> SelectPassPortTypeAll()
{
List <PassPortType> passTypes = new List <PassPortType>();
string sql = "select * from Passporttype";
MySqlDataReader dr = DBHelper.ExecuteReader(sql);
while (dr.Read())
{
PassPortType type = new PassPortType();
type.PassportId = (int)dr["PassportId"];
type.PassportName = dr["PassportName"].ToString();
passTypes.Add(type);
}
dr.Close();
DBHelper.Closecon();
return(passTypes);
}
/// <summary>
/// 添加证件类型
/// </summary>
/// <param name="passPortType"></param>
/// <returns></returns>
public bool InsertPassPortType(PassPortType passPortType)
{
return(base.Change <PassPortType>().Insert(passPortType));
}