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);
}
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);
}
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);
}
public void PXN_ResultBUS_INSERT(PXN_Result OBJ)
{
DAO.PXN_ResultDAO_INSERT(OBJ);
}
public void PXN_ResultBUS_DELETE(PXN_Result OBJ)
{
DAO.PXN_ResultDAO_DELETE(OBJ);
}
public void PXN_ResultBUS_UPDATE(PXN_Result OBJ)
{
DAO.PXN_ResultDAO_UPDATE(OBJ);
}