/// <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)); }