public int MYCOTOXIN_RESULT_Header_INSERT(MYCOTOXIN_RESULT_Header OBJ) { //if (Sql.ExecuteDataTable("SAP", "SELECT ID FROM [SYNC_NUTRICIEL].[dbo].[tbl_MYCOTOXIN_RESULT_Header_LAB] WHERE FilePath='" + OBJ.FilePath + "'", CommandType.Text).Rows[0]["ID"].ToString().Length == 0) // return 0; //else //{ Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_MYCOTOXIN_RESULT_Header_LAB] " + " ([FilePath] " + " ,[Date] " + " ,[Time] " + " ,[ReadingType] " + " ,[ReaderType] " + " ,[PlateType] " + " ,[Read] " + " ,[Wavelengths] " + " ,[ReadSpeed] " + " ,[SoftwareVersion] " + " ,[PlateNumber] " + " ,[a_SLOPE] " + " ,[b_INTERCEPT] " + " ,[R_SQUARE] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Name] " + " ,[Locked]) " + " VALUES " + "(N'" + OBJ.FilePath + "',Convert(datetime,'" + OBJ.Date + "',103),Convert(datetime,'" + OBJ.Time + "',103),N'" + OBJ.ReadingType + "',N'" + OBJ.ReaderType + "',N'" + OBJ.PlateType + "',N'" + OBJ.Read + "',N'" + OBJ.Wavelengths + "',N'" + OBJ.ReadSpeed + "',N'" + OBJ.SoftwareVersion + "',N'" + OBJ.PlateNumber + "'," + OBJ.a_SLOPE + "," + OBJ.b_INTERCEPT + "," + OBJ.R_SQUARE + ",Convert(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + "',N'" + OBJ.Name + "','" + OBJ.Locked + "')", CommandType.Text); DataTable dt = Sql.ExecuteDataTable("SAP", "SELECT ID FROM [SYNC_NUTRICIEL].[dbo].[tbl_MYCOTOXIN_RESULT_Header_LAB] " + "WHERE FilePath='" + OBJ.FilePath + "'", CommandType.Text); return(int.Parse(dt.Rows[0]["ID"].ToString())); //} }
public void MYCOTOXIN_RESULT_Header_UPDATE(MYCOTOXIN_RESULT_Header OBJ) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_MYCOTOXIN_RESULT_Header_LAB] SET" + "[FilePath] = N'" + OBJ.FilePath + "'" + ",[Date] = N'" + OBJ.Date + "'" + ",[Time] = N'" + OBJ.Time + "'" + ",[ReadingType] = N'" + OBJ.ReadingType + "'" + ",[ReaderType] = N'" + OBJ.ReaderType + "'" + ",[PlateType] = N'" + OBJ.PlateType + "'" + ",[Read] = N'" + OBJ.Read + "'" + ",[Wavelengths] = N'" + OBJ.Wavelengths + "'" + ",[ReadSpeed] = N'" + OBJ.ReadSpeed + "'" + ",[SoftwareVersion] = N'" + OBJ.SoftwareVersion + "'" + ",[PlateNumber] = N'" + OBJ.PlateNumber + "'" + ",[a_SLOPE] = " + OBJ.a_SLOPE + ",[b_INTERCEPT] = " + OBJ.b_INTERCEPT + ",[R_SQUARE] = " + OBJ.R_SQUARE + ",[CreatedDate] = Convert(datetime,'" + DateTime.Now + "',103)" + ",[CreatedBy] = N'" + OBJ.CreatedBy + "' " + ",[Note] = N'" + OBJ.Note + "' " + ",[Name] = N'" + OBJ.Name + "' " + ",[Locked] = '" + OBJ.Locked + "' " + " WHERE [ID]='" + OBJ.ID + "'", CommandType.Text); }
public int MYCOTOXIN_RESULT_Header_INSERT(MYCOTOXIN_RESULT_Header OBJ) { return(DAO.MYCOTOXIN_RESULT_Header_INSERT(OBJ)); }
public void MYCOTOXIN_RESULT_Header_UPDATE(MYCOTOXIN_RESULT_Header OBJ) { DAO.MYCOTOXIN_RESULT_Header_UPDATE(OBJ); }