public void IBD_RESULT_Lines_LABDAO_UPDATE(IBD_RESULT_Lines_LAB OBJ) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_IBD_RESULT_Lines_LAB] SET" + "[Line_No] = N'" + OBJ.Line_No + "'" + ",[IBD_RESULT_Header_LAB_ID] =" + OBJ.IBD_RESULT_Header_LAB_ID + ",[CTXN_ID] =" + OBJ.CTXN_ID + ",[OD] =" + OBJ.OD + ",[SP] = " + OBJ.SP + ",[Titer] = " + OBJ.Titer + ",[GroupTiter] = " + OBJ.GroupTiter + ",[Row] = N'" + OBJ.Row + "'" + ",[Col] = N'" + OBJ.Col + "'" + ",[Result] = N'" + OBJ.Result + "'" + ",[KHMau_GiaoMau] = N'" + OBJ.KHMau_GiaoMau + "'" + ",[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_Lines_LABDAO_INSERT(IBD_RESULT_Lines_LAB OBJ) { //XtraMessageBox.Show("LOC.Locked : " + LOC.Locked.ToString()); Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_IBD_RESULT_Lines_LAB] " + " ([Line_No] " + " ,[IBD_RESULT_Header_LAB_ID] " + " ,[CTXN_ID] " + " ,[OD] " + " ,[SP] " + " ,[Titer] " + " ,[GroupTiter] " + " ,[Row] " + " ,[Col] " + " ,[Result] " + " ,[KHMau_GiaoMau] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "(N'" + OBJ.Line_No + "'," + OBJ.IBD_RESULT_Header_LAB_ID + "," + OBJ.CTXN_ID + "," + OBJ.OD + "," + OBJ.SP + "," + OBJ.Titer + "," + OBJ.GroupTiter + ",N'" + OBJ.Row + "',N'" + OBJ.Col + "',N'" + OBJ.Result + "',N'" + OBJ.KHMau_GiaoMau + "',Convert(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + "','" + OBJ.Locked + "')", CommandType.Text); }
public void IBD_RESULT_Lines_LABDAO_INSERT(IBD_RESULT_Lines_LAB OBJ) { DAO.IBD_RESULT_Lines_LABDAO_INSERT(OBJ); }
public void IBD_RESULT_Lines_LABDAO_UPDATE(IBD_RESULT_Lines_LAB OBJ) { DAO.IBD_RESULT_Lines_LABDAO_UPDATE(OBJ); }