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);
}
