public void Save(ProductNewsModel model)
{
if (!Exists(model.ProdutID))
{
Add(model);
}
else
{
Update(model);
}
}
public ProductNewsModel GetModel(int ProductID)
{
string sql = "select * from [pdproductnews] where [productid]={0}";
sql = String.Format(sql, ProductID);
ProductNewsModel model = null;
DataTable dt = dbr.ExecuteDataSet(CommandType.Text, sql).Tables[0];
if (dt.Rows.Count > 0)
{
model = new ProductNewsModel() { ProdutID = Convert.ToInt32(dt.Rows[0]["productid"]), NewsID = Convert.ToInt32(dt.Rows[0]["newsid"]) };
}
return model;
}
public void Update(ProductNewsModel model)
{
dal.Update(model);
}
public void Delete(ProductNewsModel model)
{
dal.Delete(model);
}
public void Add(ProductNewsModel model)
{
dal.Add(model);
}
public void Update(ProductNewsModel model)
{
string sql = "update [pdproductnews] set [newsid]={0} where [productid]={1}";
sql = String.Format(sql, model.ProdutID, model.NewsID);
dbw.ExecuteNonQuery(CommandType.Text, sql);
}
public void Delete(ProductNewsModel model)
{
string sql = "delete from [pdproductnews] where [productid]={0} and [newsid]={1}";
sql = String.Format(sql, model.ProdutID, model.NewsID);
dbw.ExecuteNonQuery(CommandType.Text, sql);
}
public void Add(ProductNewsModel model)
{
string sql = "insert into [pdproductnews] ([productid],[newsid]) values ({0},{1})";
sql = String.Format(sql, model.ProdutID, model.NewsID);
dbw.ExecuteNonQuery(CommandType.Text, sql);
}