コード例 #1
0
 public void PXN_ResultDAO_INSERT(PXN_Result OBJ)
 {
     Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_PXN_Result] " +
                         " ([SoPXN] " +
                         " ,[CTXNID] " +
                         " ,[UnitTestCode] " +
                         " ,[PXN_Details_ID] " +
                         " ,[ResultLine] " +
                         " ,[ResultValue] " +
                         " ,[Positive] " +
                         " ,[ResultUoM] " +
                         " ,[CreatedDate] " +
                         " ,[CreatedBy] " +
                         " ,[Note] " +
                         " ,[Locked]) " +
                         " VALUES " +
                         "(N'" + OBJ.SoPXN +
                         "'," + OBJ.CTXNID +
                         ",N'" + OBJ.UnitTestCode +
                         "'," + OBJ.PXN_Details_ID +
                         ",N'" + OBJ.ResultLine +
                         "',N'" + OBJ.ResultValue +
                         "',N'" + OBJ.Positive +
                         "',N'" + OBJ.ResultUoM +
                         "',CONVERT(datetime,'" + DateTime.Now +
                         "',103),N'" + OBJ.CreatedBy +
                         "',N'" + OBJ.Note +
                         "','" + OBJ.Locked +
                         "')", CommandType.Text);
 }
コード例 #2
0
 public void PXN_ResultDAO_UPDATE(PXN_Result OBJ)
 {
     Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_PXN_Result] SET " +
                         " [SoPXN] = N'" + OBJ.SoPXN + "'" +
                         ",[CTXNID] = " + OBJ.CTXNID +
                         ",[UnitTestCode] = N'" + OBJ.UnitTestCode + "'" +
                         //",[PXN_Details_ID] = " + OBJ.PXN_Details_ID +
                         ",[ResultLine] = N'" + OBJ.ResultLine + "'" +
                         ",[ResultValue] = N'" + OBJ.ResultValue + "'" +
                         ",[Positive] = N'" + OBJ.Positive + "'" +
                         ",[ResultUoM] = N'" + OBJ.ResultUoM + "'" +
                         ",[CreatedDate] = CONVERT(datetime,'" + DateTime.Now + "',103)" +
                         ",[CreatedBy] = N'" + OBJ.CreatedBy + "' " +
                         ",[Note] = N'" + OBJ.Note + "' " +
                         ",[Locked] = '" + OBJ.Locked + "' " +
                         " WHERE [ID]=" + OBJ.ID, CommandType.Text);
 }
コード例 #3
0
 public void PXN_ResultDAO_DELETE(PXN_Result OBJ)
 {
     Sql.ExecuteNonQuery("SAP", "DELETE FROM [SYNC_NUTRICIEL].[dbo].[tbl_PXN_Result] " +
                         " WHERE [SoPXN]='" + OBJ.SoPXN + "' and [ResultLine]='" + OBJ.ResultLine + "'", CommandType.Text);
 }
コード例 #4
0
 public void PXN_ResultBUS_INSERT(PXN_Result OBJ)
 {
     DAO.PXN_ResultDAO_INSERT(OBJ);
 }
コード例 #5
0
 public void PXN_ResultBUS_DELETE(PXN_Result OBJ)
 {
     DAO.PXN_ResultDAO_DELETE(OBJ);
 }
コード例 #6
0
 public void PXN_ResultBUS_UPDATE(PXN_Result OBJ)
 {
     DAO.PXN_ResultDAO_UPDATE(OBJ);
 }