public int _delete(Model.Newscate mn)
{
DAL.Newscate dn = new DAL.Newscate();
int result = dn._delete(mn);
return(result);
}
public SqlDataReader sqldatareader(Model.Newscate mn)
{
DAL.Newscate dn = new DAL.Newscate();
SqlDataReader sdr = dn.sqldatareader(mn);
return(sdr);
}
public int insert(Model.Newscate mn)
{
DAL.Newscate dn = new DAL.Newscate();
int result = dn.insert(mn);
return(result);
}
public int _delete(Model.Newscate mn)
{
StringBuilder sql = new StringBuilder();
sql.Append(" delete from newscate ");
sql.Append(" where _cateid=@id ");
SqlParameter[] par = { new SqlParameter("@id", SqlDbType.Int, 4) };
par[0].Value = mn.ID;
int result = Common.DbHelperSQL.ExecuteSql(sql.ToString(), par);
return(result);
}
public SqlDataReader sqldatareader(Model.Newscate mn)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from newscate");
sql.Append(" where _cateid = @id");
SqlParameter[] par = { new SqlParameter("@id", SqlDbType.Int, 4) };
par[0].Value = mn.ID;
SqlDataReader sdr = Common.DbHelperSQL.ExecuteReader(sql.ToString(), par);
return(sdr);
}
public int update(Model.Newscate mn)
{
StringBuilder sql = new StringBuilder();
sql.Append(" update newscate set ");
sql.Append(" _catename=@name ");
sql.Append(" where _cateid = @id ");
SqlParameter[] par = { new SqlParameter("@name", SqlDbType.VarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4) };
par[0].Value = mn.Catename;
par[1].Value = mn.ID;
int result = Common.DbHelperSQL.ExecuteSql(sql.ToString(), par);
return(result);
}
public int insert(Model.Newscate mn)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into newscate");
sql.Append(" values (");
sql.Append(" @username ");
sql.Append(")");
SqlParameter[] par =
{
new SqlParameter("@username", SqlDbType.VarChar, 50)
};
par[0].Value = mn.Catename;
int result = Common.DbHelperSQL.ExecuteSql(sql.ToString(), par);
return(result);
}
