예제 #1
0
 public void Update_SoPO(string SoPO)
 {
     Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_Info] SET PONumber = '" + SoPO + "'", CommandType.Text);
 }
예제 #2
0
 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);
 }
예제 #3
0
 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();
 }
예제 #4
0
 public void PO_Header_DELETE(int ID)
 {
     Sql.ExecuteNonQuery("SAP", "   DELETE FROM [SYNC_NUTRICIEL].[dbo].[tbl_PO_Header_LAB] " +
                                 " WHERE [ID]=" + ID, CommandType.Text);
 }