/// <summary>
/// 添加证件类型
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_IDTypeTableData(IDType_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@IDT_Name", obj.IDT_Name)
}));
}
/// <summary>
/// 获取全部的证件类型
/// </summary>
/// <returns></returns>
public List <IDType_Table> GetIDTypeTableAll()
{
List <IDType_Table> list = new List <IDType_Table>();
SqlDataReader dr = DBHerlper.ExecuteReader(GetSqlString("Select"),
CommandType.StoredProcedure);
while (dr.Read())
{
IDType_Table obj = new IDType_Table()
{
IDT_Name = dr["IDT_Name"].ToString(),
IDT_id = Convert.ToInt32(dr["IDT_id"])
};
list.Add(obj);
}
dr.Close();
DBHerlper.CloseConn();
return(list);
}
/// <summary>
/// 根据ID查询证件类型信息
/// </summary>
/// <param name="con"></param>
/// <returns></returns>
public IDType_Table GetIDTypeTableByConn(string con)
{
IDType_Table obj = null;
SqlDataReader dr = DBHerlper.ExecuteReader(
"Select * from IDType_Table where IDT_id=@IDT_id",
CommandType.Text, new SqlParameter[] {
new SqlParameter("@IDT_id", con)
});
if (dr.Read())
{
obj = new IDType_Table()
{
IDT_Name = dr["IDT_Name"].ToString(),
IDT_id = Convert.ToInt32(dr["IDT_id"])
};
}
dr.Close();
DBHerlper.CloseConn();
return(obj);
}
/// <summary>
/// 更改证件类型信息
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_IDTypeTableData(IDType_Table obj)
{
return(relevanceClass.Update_IDTypeTableData(obj));
}
/// <summary>
/// 添加证件类型信息
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_IDTypeTableData(IDType_Table obj)
{
return(relevanceClass.Insert_IDTypeTableData(obj));
}
