public void MYCOTOXIN_RESULT_Lines_INSERT(MYCOTOXIN_RESULT_Lines OBJ) { //XtraMessageBox.Show("LOC.Locked : " + LOC.Locked.ToString()); Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_MYCOTOXIN_RESULT_Lines_LAB] " + " ([MYCOTOCXIN_RESULT_Header_LAB_ID] " + " ,[CTXN_ID] " + " ,[Acronym] " + " ,[OD] " + " ,[KHMau] " + " ,[B_Bo] " + " ,[LogitB_Bo] " + " ,[LogConc] " + " ,[Conc_ng_ml] " + " ,[Conc_ng_g] " + " ,[Row] " + " ,[Col] " + " ,[HsoPhaLoang] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "(" + OBJ.MYCOTOCXIN_RESULT_Header_LAB_ID + "," + OBJ.CTXN_ID + ",N'" + OBJ.Acronym + "'," + OBJ.OD + ",N'" + OBJ.KHMau + "'," + OBJ.B_Bo + "," + OBJ.LogitB_Bo + "," + OBJ.LogConc + "," + OBJ.Conc_ng_ml + "," + OBJ.Conc_ng_g + ",N'" + OBJ.Row + "'," + OBJ.Col + "," + OBJ.HsoPhaLoang + ",Convert(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + "','" + OBJ.Locked + "')", CommandType.Text); }
public void MYCOTOXIN_RESULT_Lines_UPDATE(MYCOTOXIN_RESULT_Lines OBJ) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_MYCOTOXIN_RESULT_Lines_LAB] SET" + "[MYCOTOCXIN_RESULT_Header_LAB_ID] = " + OBJ.MYCOTOCXIN_RESULT_Header_LAB_ID + ",[CTXN_ID] =" + OBJ.CTXN_ID + ",[Acronym] =N'" + OBJ.Acronym + "'" + ",[OD] = " + OBJ.OD + ",[KHMau] = N'" + OBJ.KHMau + "'" + ",[B_Bo] = " + OBJ.B_Bo + ",[LogitB_Bo] = " + OBJ.LogitB_Bo + ",[LogConc] = " + OBJ.LogConc + ",[Conc_ng_ml] = " + OBJ.Conc_ng_ml + ",[Conc_ng_g] = " + OBJ.Conc_ng_g + ",[HsoPhaLoang] = " + OBJ.HsoPhaLoang + ",[Row] = N'" + OBJ.Row + "'" + ",[Col] = " + OBJ.Col + ",[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 MYCOTOXIN_RESULT_Lines_INSERT(MYCOTOXIN_RESULT_Lines OBJ) { DAO.MYCOTOXIN_RESULT_Lines_INSERT(OBJ); }
public void MYCOTOXIN_RESULT_Lines_UPDATE(MYCOTOXIN_RESULT_Lines OBJ) { DAO.MYCOTOXIN_RESULT_Lines_UPDATE(OBJ); }