public void IBD_RESULT_Header_LABDAO_UPDATE(IBD_RESULT_Header_LAB OBJ) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_IBD_RESULT_Header_LAB] SET" + "[FilePath] = N'" + OBJ.FilePath + "'" + ",[FileName] = N'" + OBJ.FileName + "'" + ",[Date] = N'" + OBJ.Date + "'" + ",[Time] = N'" + OBJ.Time + "'" + ",[Case] = N'" + OBJ.Case + "'" + ",[KHMau_GiaoMau] = N'" + OBJ.KHMau_GiaoMau + "'" + ",[Count] = " + OBJ.Count + ",[GMean] = " + OBJ.GMean + ",[Mean] = " + OBJ.Mean + ",[SD] = " + OBJ.SD + ",[CV] = " + OBJ.CV + ",[Min] = " + OBJ.Min + ",[Max] = " + OBJ.Max + ",[Tech] = " + OBJ.Tech + ",[HUYETTHANHHOC_STD_VALUE_ID] = " + OBJ.HUYETTHANHHOC_STD_VALUE_ID + ",[CTXN_ID] = " + OBJ.CTXN_ID + ",[CreatedDate] = Convert(datetime,'" + DateTime.Now + "',103)" + ",[CreatedBy] = N'" + OBJ.CreatedBy + "' " + ",[Note] = N'" + OBJ.Note + "' " + ",[Locked] = '" + OBJ.Locked + "' " + " WHERE [ID]='" + OBJ.ID + "'", CommandType.Text); }
public int IBD_RESULT_Header_LABDAO_INSERT(IBD_RESULT_Header_LAB OBJ) { return(DAO.IBD_RESULT_Header_LABDAO_INSERT(OBJ)); }
public void IBD_RESULT_Header_LABDAO_UPDATE(IBD_RESULT_Header_LAB OBJ) { DAO.IBD_RESULT_Header_LABDAO_UPDATE(OBJ); }
public int IBD_RESULT_Header_LABDAO_INSERT(IBD_RESULT_Header_LAB 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_IBD_RESULT_Header_LAB] " + " ([FilePath] " + " ,[FileName] " + " ,[Date] " + " ,[Time] " + " ,[Case] " + " ,[KHMau_GiaoMau] " + " ,[Count] " + " ,[GMean] " + " ,[Mean] " + " ,[SD] " + " ,[CV] " + " ,[Min] " + " ,[Max] " + " ,[Tech] " + " ,[Neg] " + " ,[Pos] " + " ,[Sus] " + " ,[HUYETTHANHHOC_STD_VALUE_ID] " + " ,[CTXN_ID] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "(N'" + OBJ.FilePath + "',N'" + OBJ.FileName + "',Convert(datetime,N'" + OBJ.Date + "',103),N'" + OBJ.Time + "',N'" + OBJ.Case + "',N'" + OBJ.KHMau_GiaoMau + "'," + OBJ.Count + "," + OBJ.GMean + "," + OBJ.Mean + "," + OBJ.SD + "," + OBJ.CV + "," + OBJ.Min + "," + OBJ.Max + ",'" + OBJ.Tech + "'," + OBJ.Neg + "," + OBJ.Pos + "," + OBJ.Sus + "," + OBJ.HUYETTHANHHOC_STD_VALUE_ID + "," + OBJ.CTXN_ID + ",Convert(datetime,N'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + "','" + OBJ.Locked + "')", CommandType.Text); DataTable dt = Sql.ExecuteDataTable("SAP", "SELECT ID FROM [SYNC_NUTRICIEL].[dbo].[tbl_IBD_RESULT_Header_LAB] " + "WHERE FileName='" + OBJ.FileName + "' and CTXN_ID=" + OBJ.CTXN_ID, CommandType.Text); return(int.Parse(dt.Rows[0]["ID"].ToString())); //} }