/// <summary>
/// 添加邮箱
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_MailTableData(Mail_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@M_Mail", obj.M_Mail),
new SqlParameter("@M_YesNo", obj.M_YesNo)
}));
}
/// <summary>
/// 获取全部的邮箱
/// </summary>
/// <returns></returns>
public List <Mail_Table> GetMailTableAll()
{
List <Mail_Table> list = new List <Mail_Table>();
SqlDataReader dr = DBHerlper.ExecuteReader(GetSqlString("Select"),
CommandType.StoredProcedure);
while (dr.Read())
{
Mail_Table obj = new Mail_Table()
{
M_id = Convert.ToInt32(dr["M_id"]),
M_Mail = dr["M_Mail"].ToString(),
M_YesNo = dr["M_YesNo"].ToString()
};
list.Add(obj);
}
dr.Close();
return(list);
}
/// <summary>
/// 根据ID查询邮箱信息
/// </summary>
/// <param name="con"></param>
/// <returns></returns>
public Mail_Table GetMailTableByConn(string con)
{
Mail_Table obj = null;
SqlDataReader dr = DBHerlper.ExecuteReader(
"Select * from Mail_Table where M_id=@M_id",
CommandType.Text, new SqlParameter[] {
new SqlParameter("@M_id", con)
});
if (dr.Read())
{
obj = new Mail_Table()
{
M_id = Convert.ToInt32(dr["M_id"]),
M_Mail = dr["M_Mail"].ToString(),
M_YesNo = dr["M_YesNo"].ToString()
};
}
dr.Close();
return(obj);
}
/// <summary>
/// 更改邮箱信息
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_MailTableData(Mail_Table obj)
{
return(relevanceClass.Update_MailTableData(obj));
}
/// <summary>
/// 添加邮箱信息
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_MailTableData(Mail_Table obj)
{
return(relevanceClass.Insert_MailTableData(obj));
}
