public void HMKT_UPDATE(HangMucKiemTra OBJ) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_HangMucKiemTra] SET" + "[HMKTVN] = N'" + OBJ.HMKT + "'" + ",[HMKTEN] = N'" + OBJ.HMKTEN + "'" + ",[Characteristic] = N'" + OBJ.Characteristic + "'" + ",[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 HMKT_INSERT(HangMucKiemTra OBJ) { //XtraMessageBox.Show("LOC.Locked : " + LOC.Locked.ToString()); Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_HangMucKiemTra] " + " ([HMKTVN] " + " ,[HMKTEN] " + " ,[Characteristic] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "(N'" + OBJ.HMKT + "',N'" + OBJ.HMKTEN + "',N'" + OBJ.Characteristic + "',CONVERT(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + "','" + OBJ.Locked + "')", CommandType.Text); }
public void HMKT_DELETE(HangMucKiemTra OBJ) { Sql.ExecuteNonQuery("SAP", "DELETE FROM [SYNC_NUTRICIEL].[dbo].[tbl_HangMucKiemTra] " + " WHERE [ID]=" + OBJ.ID, CommandType.Text); }