public DataSet getKindTreatmentInfo(KindTreatment w) { DataSet ds = new DataSet(); string SqlStr = string.Format("select * from KindTreatments where Number={0}", w.Id); ds = ReturnDS(SqlStr); return(ds); }
public void DeleteKindTreatment(KindTreatment w) { string SqlStr = string.Format("delete from KindTreatments where Number={0}", w.Id); InsDelUpd(SqlStr); }
public void UpdateKindTreatment(KindTreatment w) { string sqlstr = string.Format("update KindTreatments set Kind='{0}', Price={1} where Number={2}", w.Kind, w.Price, w.Id); InsDelUpd(sqlstr); }
public void insertTreatmentKind(KindTreatment w) { string SqlStr = string.Format("insert into KindTreatments(Number, KindTreatment, Price )values({0},'{1}','{2}')", w.Id, w.Kind, w.Price); InsDelUpd(SqlStr); }