public void Insert(Common.ArmDatum dm) { SqlParameter[] prms = new SqlParameter[3]; prms[0] = new SqlParameter("@title", dm.Title); prms[1] = new SqlParameter("@Link", dm.Link); prms[2] = new SqlParameter("@Pic", dm.Pic); sh.ExecuteNonQuery("shop_arm_insert", prms); }
public void Update(Common.ArmDatum dm) { SqlParameter[] prms = new SqlParameter[4]; prms[0] = new SqlParameter("@title", dm.Title); prms[1] = new SqlParameter("@Link", dm.Link); prms[2] = new SqlParameter("@Pic", dm.Pic); prms[3] = new SqlParameter("@id", dm.Id); sh.ExecuteNonQuery("shop_arm_update", prms); }
public DataTable SelectOne(Common.ArmDatum dm) { return(dl.SelectOne(dm)); }
public void Update(Common.ArmDatum dm) { dl.Update(dm); }
public void Delete(Common.ArmDatum dm) { dl.Delete(dm); }
public void Insert(Common.ArmDatum dm) { dl.Insert(dm); }
public DataTable SelectOne(Common.ArmDatum dm) { SqlParameter[] prms = new SqlParameter[1]; prms[0] = new SqlParameter("@Id", dm.Id); return(sh.ExecuteDataSet("shop_arm_Select_One", prms)); }
public void Delete(Common.ArmDatum dm) { SqlParameter[] prms = new SqlParameter[1]; prms[0] = new SqlParameter("@id", dm.Id); sh.ExecuteNonQuery("shop_arm_delete", prms); }