示例#1
0
        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()));
            //}
        }
示例#2
0
 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);
 }