public void Update_SoPO(string SoPO)
{
Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_Info] SET PONumber = '" + SoPO + "'", CommandType.Text);
}
public DataTable PO_Header_SELECT(string SoPO)
{
return Sql.ExecuteDataTable("SAP", "SELECT * FROM [SYNC_NUTRICIEL].[dbo].[tbl_PO_Header_LAB] " +
" WHERE [SoPO]='" + SoPO + "'", CommandType.Text);
}
public string Issued_SoPO()
{
DataTable dt = Sql.ExecuteDataTable("SAP", "SELECT PONumber FROM [SYNC_NUTRICIEL].[dbo].[tbl_Info] WHERE ID = 1", CommandType.Text);
return dt.Rows[0]["PONumber"].ToString();
}
public void PO_Header_DELETE(int ID)
{
Sql.ExecuteNonQuery("SAP", " DELETE FROM [SYNC_NUTRICIEL].[dbo].[tbl_PO_Header_LAB] " +
" WHERE [ID]=" + ID, CommandType.Text);
}