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