public DataSet GetIteminfo(sales s) { DataSet ds = new DataSet(); string SqlStr = string.Format("select * from sales where SaleNo={0}", s.SaleNo); ds = ReturnDS(SqlStr); return(ds); }
private void salesProductToolStripMenuItem_Click(object sender, EventArgs e) { sales ss = new sales(); ss.Show(); }
private void menusales_Click(object sender, EventArgs e) { sales i = new sales(); i.Show(); }
private void רישוםהזמנהToolStripMenuItem_Click(object sender, EventArgs e) { sales i = new sales(); i.Show(); }
//עדכון פרטי מורה public void Update(sales s) { string SqlStr = string.Format("update sales set clientId={0} ,worekerId={1},saleDate='{2}',total={3},quantity={4} where saleNo={5}", s.SaleNo, s.ClientId, s.idSup, s.SaleDate, s.Total, s.Quantity); InsDelUpd(SqlStr); }
//מחיקת מורה public void Delete(sales s) { string SqlStr = string.Format("delete from sales where SaleNo={0}", s); InsDelUpd(SqlStr); }
//הוספת הזמנה public void Insert(sales s) { string SqlStr = string.Format("insert into sales(saleNo,clientId,workerId,saleDate,total,quantity)values({0},{1},{2},'{3}',{4},{5})", s.SaleNo, s.ClientId, s.idSup, s.SaleDate, s.Total, s.Quantity); InsDelUpd(SqlStr); }