public void IBD_RESULT_Summary_LABDAO_INSERT(IBD_RESULT_Summary_LAB OBJ) { //XtraMessageBox.Show("LOC.Locked : " + LOC.Locked.ToString()); Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_IBD_RESULT_Summary_LAB] " + " ([Type] " + " ,[IBD_RESULT_Header_LAB_ID] " + " ,[AMean] " + " ,[GMean] " + " ,[SD] " + " ,[CV] " + " ,[Min] " + " ,[Max] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "(N'" + OBJ.Type + "'," + OBJ.IBD_RESULT_Header_LAB_ID + "," + OBJ.AMean + "," + OBJ.GMean + "," + OBJ.SD + "," + OBJ.CV + "," + OBJ.Min + "," + OBJ.Max + ",Convert(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + "','" + OBJ.Locked + "')", CommandType.Text); }
public void IBD_RESULT_Summary_LABDAO_UPDATE(IBD_RESULT_Summary_LAB OBJ) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_IBD_RESULT_Summary_LAB] SET" + "[Type] = N'" + OBJ.Type + "'" + ",[IBD_RESULT_Header_LAB_ID] =" + OBJ.IBD_RESULT_Header_LAB_ID + ",[AMean] =" + OBJ.AMean + ",[GMean] = " + OBJ.GMean + ",[SD] = " + OBJ.SD + ",[CV] = " + OBJ.CV + ",[Min] = N'" + OBJ.Min + "'" + ",[Max] = N'" + OBJ.Max + "'" + ",[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 IBD_RESULT_Summary_LABDAO_INSERT(IBD_RESULT_Summary_LAB OBJ) { DAO.IBD_RESULT_Summary_LABDAO_INSERT(OBJ); }
public void IBD_RESULT_Summary_LABDAO_UPDATE(IBD_RESULT_Summary_LAB OBJ) { DAO.IBD_RESULT_Summary_LABDAO_UPDATE(OBJ); }