public void Update(DS_ShopConfig ShopConfig)
{
using (var ct = new DS_ShopConfigDataContext(DbHelperSQL.Connection))
{
ct.DS_ShopConfig.Attach(ShopConfig, true);
ct.SubmitChanges();
}
}
public void Add(DS_ShopConfig ShopConfig)
{
using (var ct = new DS_ShopConfigDataContext(DbHelperSQL.Connection))
{
ct.DS_ShopConfig.InsertOnSubmit(ShopConfig);
ct.SubmitChanges();
}
}
public void Delete(int ID)
{
using (var ct = new DS_ShopConfigDataContext(DbHelperSQL.Connection))
{
DS_ShopConfig st = ct.DS_ShopConfig.Single(a => a.ID == ID);
ct.DS_ShopConfig.DeleteOnSubmit(st);
ct.SubmitChanges();
}
}
public void Delete(string Ids)
{
using (var ct = new DS_ShopConfigDataContext(DbHelperSQL.Connection))
{
string[] idarray = Ids.Split(',');
var list = ct.DS_ShopConfig.Where(a => idarray.Contains(a.ID.ToString()));
ct.DS_ShopConfig.DeleteAllOnSubmit(list);
ct.SubmitChanges();
}
}
